WordPress.org

Ready to get started?Download WordPress

Forums

Database Got error 130 from storage engine (4 posts)

  1. JUnderstudy
    Member
    Posted 6 years ago #

    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.

  2. MichaelH
    Member
    Posted 6 years ago #

    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.

  3. JUnderstudy
    Member
    Posted 6 years ago #

    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.

  4. gputz
    Member
    Posted 6 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic