WordPress.org

Ready to get started?Download WordPress

Forums

Keep getting WordPress database error: [Can't open file: 'wp_comments.MYI' (5 posts)

  1. nolageek
    Member
    Posted 7 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 7 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 7 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 7 years ago #

    Thank you, thank you, thank you, justinbaeder!

  5. davidmsc
    Member
    Posted 7 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.

About this Topic

Tags