Title: Comments Crashed
Last modified: August 19, 2016

---

# Comments Crashed

 *  Resolved [homer74](https://wordpress.org/support/users/homer74/)
 * (@homer74)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/comments-crashed-1/)
 * After I recently deleted all of the spam comments my site had received, I received
   the following error message:
 * WordPress database error: [Table ‘./wordpress/wp_comments’ is marked as crashed
   and should be repaired]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved
   = ‘0’
 * This seems to be a common error message based on other postings, but I still 
   don’t understand how to resolve this?
 * any help is greatly appreciated.

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

 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/comments-crashed-1/#post-1279883)
 * To Check for crashed tables:
 *  1. Login to phpMyAdmin.
    2. Select the database and click on ‘Structure’ tab.
   3. Right under the list of table there is a “Check All” link. Click on it to 
   select all tables. 4. From a “With selected:” drop-down menu right next to it,
   choose “Check table”.
 * To Repair crashed tables:
 *  1. Login to phpMyAdmin
    2. Choose the affected database. If you only have one
   database, it should choose it by default so you don’t need to do anything. 3.
   In the main panel, you should see a list of your database tables. Check the boxes
   by the tables that need repair. 4. At the bottom of the window just below the
   list of tables, there is a drop down menu. Choose “Repair Table”
 *  Thread Starter [homer74](https://wordpress.org/support/users/homer74/)
 * (@homer74)
 * [16 years, 6 months ago](https://wordpress.org/support/topic/comments-crashed-1/#post-1280036)
 * Thanks a million – worked

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

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

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [homer74](https://wordpress.org/support/users/homer74/)
 * Last activity: [16 years, 6 months ago](https://wordpress.org/support/topic/comments-crashed-1/#post-1280036)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics