Title: Database error / wp_comments.MYI (?)
Last modified: August 18, 2016

---

# Database error / wp_comments.MYI (?)

 *  [eliotmail](https://wordpress.org/support/users/eliotmail/)
 * (@eliotmail)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/)
 * I updated to 1.5 about a week ago, I haven’t made any edits to WP or the server
   or MySQL, etc. in about 48 hours, suddenly this started showing up at the top
   of the site, the admin page, and at each comments section:
 * `WordPress database error: [Can't open file: 'wp_comments.MYI'. (errno: 145)]
   
   SELECT ID, COUNT( comment_ID ) AS ccount FROM wp_posts LEFT JOIN wp_comments 
   ON ( comment_post_ID = ID AND comment_approved = '1') WHERE post_status = 'publish'
   AND ID IN (92,90,88,49,87,85,82,81,80,72) GROUP BY ID
 * see this bug in action at: visualresistance.org/wordpress
 * anyone seen this before or know what might be causing it? thanks in advance….

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/#post-165353)
 * Looks like a hosting error – email them.
 *  Thread Starter [eliotmail](https://wordpress.org/support/users/eliotmail/)
 * (@eliotmail)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/#post-165354)
 * ok i’ll try that — thanks podz
 *  [cheeks](https://wordpress.org/support/users/cheeks/)
 * (@cheeks)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/#post-165906)
 * eliotmail, did you ever resolve this?
 *  [cheeks](https://wordpress.org/support/users/cheeks/)
 * (@cheeks)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/#post-165907)
 * Found the answer! In PHPMyAdmin you need to type:
 * `REPAIR tablename USE_FRM`
 * This should sort it out.
 *  [cheeks](https://wordpress.org/support/users/cheeks/)
 * (@cheeks)
 * [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/#post-165908)
 * Oops! Try:
 * REPAIR TABLE `tablename` USE_FRM

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

The topic ‘Database error / wp_comments.MYI (?)’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 5 replies
 * 3 participants
 * Last reply from: [cheeks](https://wordpress.org/support/users/cheeks/)
 * Last activity: [21 years, 2 months ago](https://wordpress.org/support/topic/database-error-wp_commentsmyi/#post-165908)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics