Make WordPress Core

Opened 9 years ago

Closed 9 years ago

Last modified 8 years ago

#2867 closed defect (bug) (worksforme)

MySQL 5.0.22 incompatibility

Reported by: pcdinh Owned by:
Milestone: Priority: normal
Severity: normal Version: 2.1
Component: General Keywords: mysql, database, incompatibility
Focuses: Cc:


When I run Wordpress 2.1 alpha2 under MySQL 5.0.22, I got this error message when browsing to DashBoard

WordPress database error: [Data too long for column 'option_value' at row 1]
UPDATE wp_options SET option_value = 'O:9:\"MagpieRSS\":19:{s:6:\"parser\";i:0;s:12:\"current_item\";a:0:{}s:5:\"items\";a:10:{i:0;a:12:{s:5:\"title\";s:15:\"WordPress 2.0.3\";s:4:\"link\";s:55:\"http://wordpress.org/development/2006/06/wordpress-203/\";s:8:\"comments\";s:64:\"http://wordpress.org/development/2006/06/wordpress-203/#comments\";s:7:\"pubdate\";s:31:\"Thu, 01 Jun 2006 07:49:38 +0000\";s:2:\"dc\";a:1:{s:7:\"creator\";s:4:\"Matt\";}s:8:\"category\";s:11:\"Development\";s:4:\"guid\";s:55:\"http://wordpress.org/development/2006/06/wordpress-203/\";s:11:\"description\";s:321:\"The latest in the stable 2.0 series, 2.0.3, is now available for download. This is a bug fix and security release, and is recommended for all WordPress users. In addition to an issue that was raised on Bugtraq a few days ago, we’ve also backported a number of security enhancements from 2.1 to further enhance [...]\";s:7:\"content\";a:1:{s:7:\"encoded\";s:886:\"

Change History (4)

comment:1 @robmiller9 years ago

Hmm, option_value is a longtext, a field-type which has a maximum length of 4,294,967,295 characters - somehow I don't think the RSS cache is filling that! Check what field-type yours is.

comment:2 @darkfate9 years ago

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

Yea, I have the same version and it works for me

comment:3 @robmiller9 years ago

To clarify, this is an issue you should take to the support forum; it's a problem with your server/database rather than a defect in WP itself :)

comment:4 @Nazgul8 years ago

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