Support » Fixing WordPress » Keep getting WordPress database error: [Can’t open file: ‘wp_comments.MYI’

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

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

    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.

    Thank you, thank you, thank you, justinbaeder!

    davidmsc

    (@davidmsc)

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Keep getting WordPress database error: [Can’t open file: ‘wp_comments.MYI’’ is closed to new replies.