Comments suddenly broken – DB Error

  • Harvey

    (@harvey)


    19 years, 9 months ago

    Hello,

    Suddenly the comments on my blog seem to be broken. They cannot be displayed and are returning a DB Error.

    The site is here, http://www.japannewbie.com, and the error looks liek this.


    WordPress database error: [Can't open file: 'wp_comments.MYI' (errno: 144)]
    SELECT comment_author, comment_author_url, comment_ID, comment_post_ID FROM wp_comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 5

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

    The same comment error pops up everywhere in my board where comments are meant to be displayed. Including the sidebar, individual posts, and also in the admin control panel.

    Anyone know how I could get this fixed?

    I’m not sure if it is a problem with WP or a prob with my database… mysql.

    Thanks for any help!

    – Harvey

Viewing 3 replies - 1 through 3 (of 3 total)
  • Chris_K

    (@handysolo)

    19 years, 9 months ago

    Contact your host: When you see errno: xxx you’re having a MySQL database issue (not a WP issue).

    You might also google for the error. Some of the MySQL errors can be repaired with tools like phpMyAdmin. Sometimes. But if in doubt, definitely contact your host’s tech support.

    Thread Starter Harvey

    (@harvey)

    19 years, 9 months ago

    Hi everyone, quick fix but. I sent the same comment to my ISP, they told me my database needed to be repared. I told them the name of the DB that WP was connected to by verifying wp-config.php. They ran a repair table command in MYSQL ‘REPAIR TABLE wp_comments’, and after that everything was fine.

    Amazing.

    Thread Starter Harvey

    (@harvey)

    19 years, 9 months ago

    Wow, the problems came back again.
    Going to ask my provider to check it out again.

    Anyone had these problems reoccur on their WP DB before?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Comments suddenly broken – DB Error’ is closed to new replies.