WordPress.org

1. Pinyin
   Member
   Posted 6 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
   Member
   Posted 6 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
   Member
   Posted 6 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.