Wp Wordpress

I tried updating my wordpress and I’m getting database errors all over…

WordPress database error: [Unknown column ‘option_description’ in ‘field list’]
INSERT INTO wp_options (option_name, option_value, option_description, autoload) VALUES (’category_children’, ‘a:0:{}’, ”, ‘yes’)

Solution:

I suspected that error was there coz the field option_description somehow accidentally got deleted in my attempt to upgrade my wordpress to version 2.3.1. Here’s how I solved my problem. You ppl out there with the similar problem may try this, but I do not take resposibility for screwed up databases, ok? It’s good practice to backup your database before making any changes.

1. Login to phpMyAdmin.
2. Open the database where your wordpress tables are stored.
3. Find the wp_options table and select the Structure icon.
4. In the After field, select option_value, and click Go.
5. Fill in the table fields as follows:
* Field: option_description
* Type: TINYTEXT
6. Leave the rest of the fields as their default values.
7. Click Save.
8. Check your website if the error is still showing. If it’s not, then your work is done.

Thanks to debbiewhoelse.com

This entry was posted on Wednesday, January 16th, 2008 at 3:54 pm. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.