"I am webby and I think webby" - AjiNIMC aka Aji Issac Mathew - "I thought and I wrote".

 AjiNIMC logo - Aji Issac Mathew I am Aji Issac Mathew also known as AjiNIMC at various forums. I am webby and I think webby, being a part time blogger, this blog is a documentation of my experiences and my learning.
Blog Stats (06 June 2008): There are currently 306 posts and 1100 comments (and 397,307 spam comments), contained within 17 categories.		RSS for Aji Issac Mathew's blog 
  I am into professional Web Marketing services which includes Web marketing strategies, SEO/SEM, Content Designing, Web Designing for usability, conversion improvement and various other things. There are limited availability per month. We don't take too many clients but we make sure that all our clients get their share of success. I worked on in-house sites for over 5 years, now is the time to help others with my experience. I have a great team helping me achieve this. A very creative and experienced team. Contact aji.issac (at the rate) digitalavenues.com and get your share of success.  

 Home >

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

Jun
7

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.

This post was written by AjiNIMC aka Web Kotler at 6:59 am under category Tech Talks(



5 Comments »

  1. Thanks, for a non techy person table corruption is a scary thing.



    Mary on June 9, 2007 - 6:57 am @ 6:57 am

  2. Thanks for the fix!



    Derek on January 24, 2008 - 11:32 pm @ 11:32 pm

  3. You are welcome Derek! Thanks for the comment. I have dropped you an email.



    AjiNIMC on January 25, 2008 - 7:21 am @ 7:21 am

  4. I just did the repair thing you mentioned in cpanel and it has crashed my entire site. Im scared :S



    Alex on February 3, 2008 - 4:50 pm @ 4:50 pm

  5. 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.



    AjiNIMC on February 3, 2008 - 10:31 pm @ 10:31 pm

RSS feed for comments on this post · TrackBack URI

Share your thoughts

You are visitor number