Title: SQL commenting error
Last modified: August 18, 2016

---

# SQL commenting error

 *  [michiru37](https://wordpress.org/support/users/michiru37/)
 * (@michiru37)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/sql-commenting-error/)
 * [http://reviews.frozen-rain.net/](http://reviews.frozen-rain.net/)
 * The comments don’t show up, and in the admin panel, everywhere that has any information
   on comments has SQL errors; here’s one of the errors:
 * 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’

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

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/sql-commenting-error/#post-529563)
 * Almost always this means a table has crashed and needs repairing. Do it through
   phpmyadmin or contact your host.
 * Sometimes it means someone has mailed or tried to upload a huge attachment that
   exceeds host specs.
 *  Thread Starter [michiru37](https://wordpress.org/support/users/michiru37/)
 * (@michiru37)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/sql-commenting-error/#post-529587)
 * Well, wordpress is only acting up for that subdomain, and as far as I know, I
   haven’t touched it in a while.
 * But thank you, I’ll fiddle with the SQL for a while and contact my host.
 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/sql-commenting-error/#post-529612)
 * But a `table` is specific to one certain instance of WP. You could have 10 WP’s
   installed in one db and have a table crash and it will only affect one blog.

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

The topic ‘SQL commenting error’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [Samuel B](https://wordpress.org/support/users/samboll/)
 * Last activity: [19 years, 1 month ago](https://wordpress.org/support/topic/sql-commenting-error/#post-529612)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics