comments have disappeared (3 posts)

  1. Pinyin
    Posted 10 years ago #

    I haven't made any changes that could account for this. Last night everything worked; this morning comments have disappeared and been replaced with an error message:
    WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
    SELECT * FROM wp_comments WHERE comment_post_ID = '414' AND comment_approved = '1' ORDER BY comment_date

    Also, each page within WP admin begins with

    WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = '0'

    When I looked in phpMyAdmin, I found that collation for wp_comments is listed as being "in use". For wp_comments, unlike all other tables, "records" and "size" are blank.

    I disabled all my plugins. The problem remains.

    I'm running WP2.0.2. The host is Dreamhost.

    Any fixes or suggestions would be greatly appreciated. Many thanks.

  2. Chris_K
    Posted 10 years ago #

    You'll want to contact your host - they have a broken MySQL and I don't think there's much you can do without them to get it fixed.

  3. Pinyin
    Posted 10 years ago #

    Thanks, HandySolo!

    Here's what I received from Dreamhost:

    "The problem with your comments is that the table the comments were stored in needed a repair (which can be done via phpMyAdmin). I have repaired the table and your comments are working again. You may still see the errors, but that is simply because wp-cache has cached them. Once it refreshes, you'll be good to go."

    Everything is well now.

Topic Closed

This topic has been closed to new replies.

About this Topic