Unknown column ‘comment_date_gmt’ in ‘field lis

  • I’m getting the following errors when trying to post comments on a friend’s WORDPRESS blog:
    SQL/DB Error:
    [Unknown column 'comment_date_gmt' in 'field list']
    INSERT INTO wp1_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_approved) VALUES ('5', 'Test - DeWaun', '[email protected]', 'https://tmcinfo.dallasnews.com/', '147.136.249.101', '2004-04-05 18:32:42', '2004-04-05 22:32:42', 'This is a test.', '1')
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 111
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 112
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 113
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 115
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 116
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 117
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 118
    Warning: Cannot modify header information - headers already sent by (output started at e:\home\Default\flakepublishing.com\htdocs\wp-includes\wp-db.php:94) in e:\home\Default\flakepublishing.com\htdocs\wp-comments-post.php on line 121
    —-
    What is this and how can I fix this? I have no mySQL experience and very little PHP skills.

Viewing 5 replies - 1 through 5 (of 5 total)

  • Your friend is using a nightly build, and didn’t bother running upgrade.php.

    Thread Starter dewaun

    (@dewaun)

    bonjour, michel…
    Yes, I originally installed a nightly. But how should I proceed to correct this problem? Do I uninstall/overwrite with the milestone release? Then run the /wp-admin/upgrade.php? or what…
    How do I do the uninstall (just trash all the files and re-install)?
    As far as the UPGRADE, i did that today and it did not seem to change anything. The upgrade said it finished okay and said it was done successfully and to… “Have Fun”.
    Sorry to sound so Whiney, but I really need some support on this. Thanks in advance.

    Thread Starter dewaun

    (@dewaun)

    anyone awake?

    Thread Starter dewaun

    (@dewaun)

    It was last week (Monday to Friday) sometime. I cannot remember. I updated using upgrade.php, tonite. I finally got the POSTING COMMENTS php file to work, and the RSS and Comments-RSS and ATOM and RDF php files to work and verify (so that’s good). But I’m sure that I didn’t do anything with a “second upgrade script”. I’ll take a look at what’s going on with the two links you provided (as soon as I have some sleep) tomorrow. I’m seeing double and my eyes are sleeeeeepy.
    Thanks.

    know the feeling…good luck!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Unknown column ‘comment_date_gmt’ in ‘field lis’ is closed to new replies.