Title: Errors in comment database
Last modified: August 18, 2016

---

# Errors in comment database

 *  [carltown](https://wordpress.org/support/users/carltown/)
 * (@carltown)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/errors-in-comment-database/)
 * 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](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/errors-in-comment-database/#post-425905)
 * 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

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [Chris_K](https://wordpress.org/support/users/handysolo/)
 * Last activity: [19 years, 8 months ago](https://wordpress.org/support/topic/errors-in-comment-database/#post-425905)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics