Wordpress error? Try repairing database
Published on 24 Jul 2007 at 6:22 am.
No Comments.
Filed under Blogging, TechTips.
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:
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!
-
Related Articles on Technobiography:
|
|
