WordPress.org

1. nolageek
   Member
   Posted 6 years ago #
   

   I get this whenever wordpress tries to read comments. (Indiviual posts pages and in admin.)

   Any idea what happened? It just started doing this out of the blue.

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

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

2. Chris_K
   Member
   Posted 6 years ago #
   

   Anytime you see "errno: " you can safely assume there's something unhappy about MySQL. As such, you'll want to contact your host with that error message so that they can fix it.

3. justinbaeder
   Member
   Posted 6 years ago #
   

   I got a similar error today for no apparent reason. I disabled Akismet, and it went away, but I didn't want to leave Akismet disabled.

   I opened PHPMyAdmin, selected the wp_contents table, and selected Operations -> Repair.

   This did it - the operation repair got rid of the error.

4. eija
   Member
   Posted 6 years ago #
   

   Thank you, thank you, thank you, justinbaeder!

5. davidmsc
   Member
   Posted 6 years ago #
   

   WOW! I started getting the same error message today, and justinbaeder's advice worked like a charm -- thanks!

Topic Closed

This topic has been closed to new replies.