WordPress database error: [Got error 127 from storage Engine]

I know I am not blogging for last few days, got busy with new recruits. After almost an year (Last time it was when we hired (mass hiring) few programmers and Marketing guys from Army Institute of Management and other B-Schools) I revamped the whole Mentoring program. I am liking this mentorship program as it has the right blend of tech and non-tech dimension. I will post more about it.

Meanwhile I was getting this error
WordPress database error: [Got error 127 from storage Engine]
WordPress database error: [Got error 127 from storage Engine]
SELECT COUNT(comment_ID) FROM wp_comments Where Comment_approved =”Spam”

Error 127

Initially I thought it can be akismet related error and gave it a day. Today after a good 8 hour sleep I just did a search on Error 127 to find “Error 127 indicates a record has crashed”. When there is a crash you need to do a repair.

How to repair WordPress database error

If you are a non-techy guy (or want simpler solution),

  1. Go to cpanel
  2. MySql Databases
  3. See your database
  4. You will see a button named repair under your blog database, click on it and it will take care of it.

If you are a little techy,

  1. use the phpmyadmin
  2. In the main panel, you should see a list of your database tables. Check the boxes by the tables that need repair.
  3. At the bottom of the window just below the list of tables, there is a drop down menu. Choose “Repair Table”.

Even you can do it manually using REPAIR TABLE `wp_useronline` etc. I just did a search for similar error and saw many going through such phase. Hope this article helps.

5 thoughts on “WordPress database error: [Got error 127 from storage Engine]

  1. AjiNIMC Post author

    Hi Alex,

    Thats the fun part of the technical things, if you know it then it is the most easiest thing on the planet else nothing defines the difficulty level.

    Now take these steps:
    1) Try to access the database through any client, see what all tables are accessible.

Leave a Reply

Your email address will not be published. Required fields are marked *