WordPress.org

Support

Support » How-To and Troubleshooting » Database Got error 130 from storage engine

Database Got error 130 from storage engine

  • I was unfortunately away from my admin for a while. When I checked it today I noticed a couple of error messages both in my admin and my front page (intheoryblog.com):

    WordPress database error: [Got error 130 from storage engine]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’

    WordPress database error: [Got error 130 from storage engine]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’

    This error appears anywhere where I could see or edit comments, so it’s almost as if I have no comments.

    I do know that there were a lot of comments both in the “to be moderated” and the spam queues. Could this have anything to do with an overload of these comments? Is this a fix I could make happen on my own? Is this an issue I need to resolve with my host?

    I’m not entirely comfortable with dealing with backend stuff, but I can usually feel my way through it. Here, I’m lost. Any help is much appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Not seeing this error on your blog.

    Make sure you have a backup of your database just in case.

    Might also see if your host has any input.

    This link –

    http://intheoryblog.com/2007/08/02/almost-home/#comments

    gives me the following message where my comments should be:

    WordPress database error: [Got error 130 from storage engine]
    SELECT * FROM wp_comments WHERE comment_post_ID = ‘471’ AND comment_approved = ‘1’ ORDER BY comment_date

    I’m not sure what the last database backup I have, but I’d like to know if that’s the likely fix before I start digging.

    Encountered this exact same problem recently:

    WordPress database error: [Got error 130 from storage engine]
    SELECT COUNT(*) FROM wp_comments WHERE comment_approved = ‘0’

    WordPress database error: [Got error 130 from storage engine]
    SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_approved = ‘spam’

    I tried to repair the mySQL tables, specifically wp_comments, but it still wouldn’t budge. It happened to be corrupt. I don’t know the cause.

    I called up my web host and they restored a recent backup of the database. Everything started to work again. If anyone encounters this problem and needs a quick fix, just restore the latest backup.

    Hope that helps!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Got error 130 from storage engine’ is closed to new replies.
Skip to toolbar