WordPress error? Try repairing database

by Ka Edong on July 24, 2007

Disclaimer: This worked for me. There are no promises that it will work for you.

I’ve encountered a wordpress database error twice in the past and this the error message of the latest one:

WordPress database error: [Table ‘wp_comments’ is marked as crashed and last (automatic?) repair failed]
SELECT * FROM wp_comments WHERE comment_post_ID = ‘320’ AND ( comment_approved = ‘1’ OR ( comment_author = ‘ka edong’ AND comment_author_email = ‘edongskey@gmail.com’ AND comment_approved = ‘0’ ) ) ORDER BY comment_date

Here is the solution that worked for me, and it especially worked well for me because of the guiding photographs (thanks Paul!):

How To Quickie: Repair MySQL Tables

In my case, repairing the tables with overhead did not fix the error. But repairing the “wp_comments” table was the one that did the trick. The tell tale sign was not the overhead, but the message saying “in use” which was different from the rest of the tables.

Here’s a similar (same?) solution, but with illustrations for a different version of phpAdmin:

Repairing database tables

I’m keeping this for my personal reference for the next time it happens to me. And for anybody else looking for a solution to a similar problem.

Hope that helps.

ka edong
fix me! fix me!

Comments

Previous post:

Next post: