Comments Crashed

  • Resolved homer74

    (@homer74)


    15 years ago

    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

    (@whooami)

    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

    (@homer74)

    Thanks a million – worked

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Comments Crashed’ is closed to new replies.