Make WordPress Core

Opened 14 years ago

Closed 10 years ago

Last modified 10 years ago

#13875 closed defect (bug) (duplicate)

Upgrading from pre-2.3.0 yields database errors

Reported by: tinne's profile tinne Owned by:
Milestone: Priority: normal
Severity: normal Version: 2.9.2
Component: Upgrade/Install Keywords:
Focuses: Cc:

Description

When upgrading a 2.2.3 to 3.0-rc3 using wp-admin/upgrade.php, three database errors appear signaling that delete_site_transient() misfunctions, as a column value for option_description is not given
(in a way, this is #4921 again).

The upgrade script should either a) give a default value to that column or b) delete it earlier in the upgrade process.

--8<-- (error msgs follow)

WordPress database error: [Field 'option_description' doesn't have a default value]
INSERT INTO options (option_name, option_value, autoload) VALUES ('_transient_doing_cron', '1276472580', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

WordPress database error: [Field 'option_description' doesn't have a default value]
INSERT INTO options (option_name, option_value, autoload) VALUES ('_site_transient_timeout_theme_roots', '1276479782', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

WordPress database error: [Field 'option_description' doesn't have a default value]
INSERT INTO options (option_name, option_value, autoload) VALUES ('_site_transient_theme_roots', 'a:2:{s:15:\"philippus-do-de\";s:7:\"/themes\";s:9:\"twentyten\";s:7:\"/themes\";}', 'yes') ON DUPLICATE KEY UPDATE option_name = VALUES(option_name), option_value = VALUES(option_value), autoload = VALUES(autoload)

Change History (4)

#1 @tinne
14 years ago

  • Cc karsten.tinnefeld@… added

#2 @nacin
14 years ago

  • Milestone changed from Awaiting Review to Future Release

I get to update a friend's site from pre 2.3 to 3.0 in the next few weeks. I will watch out for this.

#3 @chriscct7
10 years ago

  • Resolution set to duplicate
  • Status changed from new to closed

Duplicate of #4921.

#4 @DrewAPicture
10 years ago

  • Milestone Future Release deleted
Note: See TracTickets for help on using tickets.