Title: Comments error
Last modified: August 19, 2016

---

# Comments error

 *  [witewolf](https://wordpress.org/support/users/witewolf/)
 * (@witewolf)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/comments-error-2-2/)
 * I have this error message top of page in my admin area:
 * 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’
 * Same thing when I try to click on to any blog comment, can’t open comments. It
   is only on one subdomain. My hosts tell me they are looking into it for weeks,
   another user has same thing they said. But has anyone any idea what this is please?

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

 *  [moshu](https://wordpress.org/support/users/moshu/)
 * (@moshu)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/comments-error-2-2/#post-862207)
 * You need to repair those DB tables. If you don’t know how – contact your host.
 *  Thread Starter [witewolf](https://wordpress.org/support/users/witewolf/)
 * (@witewolf)
 * [17 years, 11 months ago](https://wordpress.org/support/topic/comments-error-2-2/#post-862351)
 * I tried to repair database, but no result. The table said “in use”, 0kbs as though
   there was nothing there. My host said the problem has been resolved “their end”
   and I might just need to repair the database, but no different.
 *  There is also anothre mystery on comments at a seperate sub domain of mine. 
   All comments are visible on the site, and in admin recent comments are showing
   up, but if I click show all, “no comments found” comes up, even though I was 
   just looking at recent comments. If I click manage comments, “no comments found”
   again.
 * Thanks for any advice. Mark.

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

The topic ‘Comments error’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [witewolf](https://wordpress.org/support/users/witewolf/)
 * Last activity: [17 years, 11 months ago](https://wordpress.org/support/topic/comments-error-2-2/#post-862351)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics