WordPress.org

1. angi
   Member
   Posted 7 years ago #

   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 ('2', '1', '2005-02-23 10:21:19', '2005-02-23 04:51:19', 'yep', 'firsties', '', 'publish', 'open', 'open', '', 'firsties', '', '2005-02-23 10:21:19', '2005-02-23 04:51:19', '0', '0')

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

   WordPress database error: [Unknown column 'guid' in 'field list']
   UPDATE wp_posts SET guid = 'http://mom25boys.org/new/?p=' WHERE ID = '2'

2. logan_wick
   Member
   Posted 7 years ago #

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

3. Nick Momrik
   Member
   Posted 7 years ago #

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

4. Guymauve
   Member
   Posted 7 years ago #

   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.

5. galduric
   Member
   Posted 7 years ago #

   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?

6. ampersand
   Member
   Posted 7 years ago #

   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.

7. NuclearMoose
   Member
   Posted 7 years ago #

   Did you run upgrade.php ?

8. moshu
   Member
   Posted 7 years ago #

   If you copy your error message (You have an error in your SQL syntax) in the Search box... you'll find the answer :)

9. ampersand
   Member
   Posted 7 years ago #

   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

10. ampersand
    Member
    Posted 7 years ago #

    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 = 'http://www.amptoons.com/blog/archives/2005/03/15//' WHERE ID = '1412'

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

11. b-717
    Member
    Posted 6 years ago #

    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 = 'http://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

12. b-717
    Member
    Posted 6 years ago #

    Duplicate message deleted.
    Josef

13. wcrosbie
    Member
    Posted 6 years ago #

    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 = 'http://domain/~myname/wp/?p=' WHERE ID = '511'

Topic Closed

This topic has been closed to new replies.