Support » Fixing WordPress » comments have disappeared

  • 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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.

    Thread Starter Pinyin

    (@pinyin)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘comments have disappeared’ is closed to new replies.