[wp-trac] [WordPress Trac] #17439: Wordpress Database Update reports errors but says it's successfull

[WordPress Trac]

#17439: Wordpress Database Update reports errors but says it's successfull
-------------------------------+-------------------------
 Reporter:  hakre              |       Owner:
     Type:  defect (bug)       |      Status:  closed
 Priority:  normal             |   Milestone:
Component:  Upgrade/Install    |     Version:  3.2
 Severity:  normal             |  Resolution:  worksforme
 Keywords:  reporter-feedback  |
-------------------------------+-------------------------
Changes (by SergeyBiryukov):

 * keywords:  reporter-feedback 2nd-opinion close => reporter-feedback
 * status:  new => closed
 * resolution:   => worksforme
 * milestone:  Awaiting Review =>


Old description:

> I just updated my database on current HEAD of trunk by pressing the
> button while WP told be to do so. I got an error reported:
> ----
> '''WordPress database error:''' [Out of range value adjusted for column
> 'post_parent' at row 4]
> `ALTER TABLE wp_posts CHANGE COLUMN post_parent post_parent bigint(20)
> unsigned NOT NULL default '0'`
> ----
>
> However right beneath of it, I was greeted with:
>
> ----
> '''Update Complete'''
>
> Your WordPress database has been successfully updated!
> ----
>
> First of all I ask myself if I can trust that message as an error has
> been reported.
>
> Then this looks like that the update is not compatbile with my MySQL
> server which is 5.0.19 and matching the [wordpress system requirements on
> the webpage](http://wordpress.org/about/requirements/) (which seems to be
> out of date for trunk, but, well 5.0 is required according to
> version.php).
>
> Related: #3112

New description:

 I just updated my database on current HEAD of trunk by pressing the button
 while WP told be to do so. I got an error reported:
 ----
 '''WordPress database error:''' [Out of range value adjusted for column
 'post_parent' at row 4]
 `ALTER TABLE wp_posts CHANGE COLUMN post_parent post_parent bigint(20)
 unsigned NOT NULL default '0'`
 ----

 However right beneath of it, I was greeted with:

 ----
 '''Update Complete'''

 Your WordPress database has been successfully updated!
 ----

 First of all I ask myself if I can trust that message as an error has been
 reported.

 Then this looks like that the update is not compatbile with my MySQL
 server which is 5.0.19 and matching the
 [http://wordpress.org/about/requirements/ wordpress system requirements on
 the webpage] (which seems to be out of date for trunk, but, well 5.0 is
 required according to version.php).

 Related: #3112

--

Comment:

 Appears to be an edge case. We could probably fix displaying of the
 success message if there are errors, I'd suggest creating a new ticket for
 that.

--
Ticket URL: <http://core.trac.wordpress.org/ticket/17439#comment:5>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software