WordPress Error

I have been getting following errors related to WordPress database for my blog in recent days –

 

   1: WordPress database error: [Can’t open file: ‘wp_comments.MYI’. (errno: 145)]
   2:  
   3: WordPress database error: [User 'xyz' has exceeded the 'max_questions' resource (current value: 50000)] SELECT * FROM wp_users WHERE user_login = 'admin'

 

This problem occurs when one of your tables get corrupted which can happen because of any reason – can be the one you never expected like mishandling of packets while insertion to tables, sudden disconnection to database, erroneous  spam comments or posting error from your desktop blog editor.

 

In order to fix it, all you need to do is to go to your MYSQL database (prompt or phpMyAdmin), run the REPAIR TABLE command –

 
repair table wp_comments
repair table wp_users

That is it.

 

Thanks Anirudh for instant intimation.

Leave a Reply

Your email address will not be published.