WordPress database error: [Unknown column ‘menu_order’ in ‘field list’]

That means start over. Just kidding..do you have phpMyAdmin?

Are you upgrading? If so, did you run upgrade.php?

Hi – I’ve been trying to upgrade and got a similar error (well, a whole page of errors), much like this:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘( optiontype_id int(11) NOT NULL auto_increment, optionty]
CREATE TABLE ( optiontype_id int(11) NOT NULL auto_increment, optiontype_name varchar(64) NOT NULL, PRIMARY KEY (optiontype_id) )

I’ve done a database backup and this error comes up when I run upgrade.php.

Help appreciated.

Same here. I’ve been getting a similar error: “WordPress database error: [You have an error in your SQL syntax near ‘( optiontype_id int(11) NOT NULL auto_increment, optiontype_name varchar(64)’ at line 2]
CREATE TABLE ( optiontype_id int(11) NOT NULL auto_increment, optiontype_name varchar(64) NOT NULL, PRIMARY KEY (optiontype_id) )”

An entire page full of those! What’s the deal?

I’m having the exact same problem, so I thought I’d give this thread a bump. Did anyone find a solution? Please?

Edited to add:

And yes, I was upgrading; and yes, I ran upgrade.php.

I do have phpmyadmin, and I’d be happy to go add the missing column manually, if someone could look at it in their database and let me know what the various values should be set to.

Did you run upgrade.php ?

If you copy your error message (You have an error in your SQL syntax) in the Search box… you’ll find the answer ??

Sorry, Nuclear Moose, you posted as I was editing my previous post to add more info. Yes, I ran it. It said it worked.

I tried running it a second time, just now, and got an error – Fatal error: Cannot redeclare maybe_add_column() (previously declared in /home/amptoon/public_html/blog/wp-content/plugins/subscribe-to-comments.php:252) in /home/amptoon/public_html/blog/wp-admin/upgrade-functions.php on line 258

Moshu: Actually, my error looks like the error quoted by the very first poster to this thread, and doesn’t contain the phrase you quote.

Here’s the error I’m getting:

WordPress database error: [Unknown column ‘menu_order’ in ‘field list’]
INSERT INTO alas_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order) VALUES (‘1412’, ‘1’, ‘2005-03-15 11:43:04’, ‘2005-03-15 19:43:04’, ‘test’, ‘test’, ”, ‘publish’, ‘open’, ‘open’, ”, ‘test’, ”, ‘2005-03-15 11:43:04’, ‘2005-03-15 19:43:04’, ‘0’, ‘0’)

Warning: Cannot modify header information – headers already sent by (output started at /home/amptoon/public_html/blog/wp-includes/wp-db.php:98) in /home/amptoon/public_html/blog/wp-admin/post.php on line 153

WordPress database error: [Unknown column ‘guid’ in ‘field list’]
UPDATE alas_posts SET guid = ‘https://www.amptoons.com/blog/archives/2005/03/15//’ WHERE ID = ‘1412’

Would the solution you suggest work for that error, too?

Hello,

I had error messages like this:

“WordPress database error: [Unknown column ‘menu_order’ in ‘field list’]
INSERT INTO wp_posts (ID,………. menu_order) VALUES (……….)

Warning: Cannot modify header information – headers already sent by (output started at my_path/wp-includes/wp-db.php:98) in /var/www/web131/html/wp2005/wp-admin/post.php on line 170

WordPress database error: [Unknown column ‘guid’ in ‘field list’]
UPDATE wp_posts SET guid = ‘https://my_url/?p=’ WHERE ID = ‘138’ “

I opened phpMyAdmin and added to the table “wp_posts”:
field = menu_order
type = int(4)

I did not add the column “guid” (may be I do it later).

Now the error message shown above is away, a long time I hope.

Josef

Duplicate message deleted.
Josef

Briefly, I’ve just installed WP 1.5 as part of upgrading to WP 2.0.2
Intallation worked okay, but when I tried a test post I got the following errors:

WordPress database error: [Unknown column ‘menu_order’ in ‘field list’]
INSERT INTO wp_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order) VALUES (‘511’, ‘1’, ‘2006-05-17 19:17:16’, ‘2006-05-17 09:17:16’, ‘test_only by Warren Crosbie’, ‘Test’, ”, ‘publish’, ‘open’, ‘open’, ”, ‘test’, ”, ‘2006-05-17 19:17:16’, ‘2006-05-17 09:17:16’, ‘0’, ‘0’)

Warning: Cannot modify header information – headers already sent by (output started at /Users/myname/Sites/wp/wp-includes/wp-db.php:98) in /Users/myname/Sites/wp/wp-admin/post.php on line 170

WordPress database error: [Unknown column ‘guid’ in ‘field list’]
UPDATE wp_posts SET guid = ‘https://domain/~myname/wp/?p=’ WHERE ID = ‘511’