Title: WordPress database error
Last modified: August 19, 2016

---

# WordPress database error

 *  [fredsilva](https://wordpress.org/support/users/fredsilva/)
 * (@fredsilva)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-31/)
 * Can anyone help me? I’ve just recently been receiving the following messages:
 * 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’
 * And now no comments are posted and old comments can’t be viewed.

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

 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-31/#post-848813)
 * thats a corrupt table. With whatever your host makes available for accessing 
   your MySQL databse(s) you will need to repair that table.
 *  Thread Starter [fredsilva](https://wordpress.org/support/users/fredsilva/)
 * (@fredsilva)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-31/#post-848828)
 * Any ideas on how to go about repairing that table?
 *  [tsukiyono](https://wordpress.org/support/users/tsukiyono/)
 * (@tsukiyono)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-31/#post-848832)
 * If you have the WP-DBManager plug-in installed, you can repair and back-up databases
   with it.
 *  Thread Starter [fredsilva](https://wordpress.org/support/users/fredsilva/)
 * (@fredsilva)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-31/#post-848902)
 * I have WP-Database Backup activated. Is that the same as: WP-DBManager?

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

The topic ‘WordPress database error’ is closed to new replies.

## Tags

 * [Comments](https://wordpress.org/support/topic-tag/comments/)
 * [error message](https://wordpress.org/support/topic-tag/error-message/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [fredsilva](https://wordpress.org/support/users/fredsilva/)
 * Last activity: [17 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-31/#post-848902)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics