WordPress.org

Ready to get started?Download WordPress

Forums

WordPress database error: [Incorrect file format 'wp_comments'] (8 posts)

  1. mayvelous
    Member
    Posted 8 years ago #

    Hello I'm having these database errors through out the whole site.

    Every admin page showing the follow errors at the top of the page.

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = 'spam'

    All other pages with comments or comment sections also giving out the following errors.

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '153'

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT * FROM wp_comments WHERE comment_post_ID = '153' AND comment_approved = '1' ORDER BY comment_date

    Once submit new comment I'm getting this errors.

    WordPress database error: [Incorrect file format 'wp_comments']
    DELETE FROM wp_comments WHERE DATE_SUB('2006-04-02 23:54:15', INTERVAL 15 DAY) > comment_date_gmt AND comment_approved = 'spam'

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT comment_ID FROM wp_comments WHERE comment_post_ID = '153' AND ( comment_author = 'May' OR comment_author_email = 'mayvelous@gmail.com' ) AND comment_content = 'test' LIMIT 1

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT comment_date_gmt FROM wp_comments WHERE comment_author_IP = '202.62.123.178' OR comment_author_email = 'mayvelous@gmail.com' ORDER BY comment_date DESC LIMIT 1

    WordPress database error: [Incorrect file format 'wp_comments']
    INSERT INTO wp_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content, comment_approved, comment_agent, comment_type, comment_parent, user_id) VALUES ('153', 'May', 'mayvelous@gmail.com', 'http://www.mayvelous.com', '202.62.123.178', '2006-04-02 23:54:15', '2006-04-02 23:54:15', 'test', '1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.1) Gecko/20060111 Firefox/1.5.0.1', '', '0', '1')

    WordPress database error: [Incorrect file format 'wp_comments']
    SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '153' AND comment_approved = '1'

    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 'WHERE ID = '153'' at line 1]
    UPDATE wp_posts SET comment_count = WHERE ID = '153'

    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 '' at line 1]
    SELECT * FROM wp_comments WHERE comment_ID = ;

    Any idea how to solve this problem? I got that on WP 2.0.1 and now I've updated to 2.0.2 and still happening. It was fine before but I don't know how or what causes it to show those errors.
    Thanks.

  2. palmdoc
    Member
    Posted 7 years ago #

    Hi I am facing the same problem as well.

    WordPress database error: [Incorrect file format 'wp_posts']
    SELECT * FROM wp_posts WHERE ID = '1187' LIMIT 1

    Help!

  3. jaketeamseacatscom
    Member
    Posted 7 years ago #

    Same problem here. I got an email request to moderate a comment from my site...the comment was blank as was the IP address. I went to my site to moderate the comment and I saw the same errors all over my site;

    WordPress database error: [Incorrect file format 'wp_comments']

    My PHP database repair utility said that there was an error that the comment table was not closed properly and was being used by two users. I let it automatically repair it and now WordPress is saying it needs to be installed with a link to install.php Did I just get hacked? I hid the install.php file so I can sort this out before some idiot clicks on it.

    http://www.teamseacats.com

  4. Samuel B
    moderator
    Posted 7 years ago #

    OK guys, when are you going to start deactivating plugins before the install?

    Deactivate all plugins - reactivate one by one, testing in between.

  5. jaketeamseacatscom
    Member
    Posted 7 years ago #

    did it, done it. Site worked great for days since the upgrade and immediately after the email of a blank comment for moderation, things crashed.

  6. ranzino
    Member
    Posted 7 years ago #

    Same error, mine crashed over the weekend. I changed absolutely nothing on my end. It had been working fine for nearly seven months. Any other insight into this?

  7. jaketeamseacatscom
    Member
    Posted 7 years ago #

    It appears to be some sort of database error on my problem - although the email with a blank comment to be moderated is strange. However, after several attempts to reload a backup of the tables, I finally ended up deleting all the tables in my PHP WordPress database, reinstalling WordPress (it rebuilt the tables) and THEN restoring a backup. I got everything back minus one post.

  8. jaketeamseacatscom
    Member
    Posted 7 years ago #

    OK, in my case, it now looks like the FAlbum plugin I had installed was beating the heck out of my database. I un-installed and will see.

Topic Closed

This topic has been closed to new replies.

About this Topic