Errors in comment database

  • carltown

    (@carltown)


    19 years, 8 months ago

    Something seems to have damaged my comments database. I get the following message on the postings:

    WordPress database error: [Can’t open file: ‘wp_comments.MYI’. (errno: 145)]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 103 AND comment_approved = ‘1’;

    WordPress database error: [Can’t open file: ‘wp_comments.MYI’. (errno: 145)]
    SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = ‘103’ AND comment_approved = ‘1’

    Is there any easy way to fix this without reloading WordPress? Yes, I do have the spam cleanrer (Karma), but it’s been working.

Viewing 1 replies (of 1 total)
  • Chris_K

    (@handysolo)

    19 years, 8 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.

Viewing 1 replies (of 1 total)

The topic ‘Errors in comment database’ is closed to new replies.

Tags