WordPress.org

Make WordPress Core

Opened 4 years ago

Last modified 3 years ago

#13875 new defect (bug)

Upgrading from pre-2.3.0 yields database errors

Reported by: tinne Owned by:
Milestone: Future Release 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 (2)

comment:1 tinne4 years ago

  • Cc karsten.tinnefeld@… added

comment:2 nacin3 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.

Note: See TracTickets for help on using tickets.