WordPress.org

Ready to get started?Download WordPress

Forums

SpamKarma2 Suddenly Died (6 posts)

  1. Kalen
    Member
    Posted 9 years ago #

    so, i logged in one day and suddenly spam karma 2 had went basically haywire. i tried reinstalling the plugin and i'm still getting the same error, which is:

    Can't fetch comments.
    Query: SELECT posts_table.post_title, spam_table.karma, spam_table.id as spam_id,spam_table.karma_cmts, comments_table.* FROM wp_comments AS comments_table, wp_posts AS posts_table LEFT JOIN wp_sk2_spams AS spam_table ON spam_table.comment_ID = comments_table.comment_ID WHERE comment_approved != '1' AND posts_table.ID = comments_table.comment_post_ID ORDER BY comments_table.comment_date_gmt DESC LIMIT 30
    SQL error: Can't open file: 'wp_sk2_spams.MYI'. (errno: 145)

    i'm not sure why this is happening... or what file the wp_sk2_spams.MYI file is... can someone help?

    notes:
    1) i have tried reinstalling
    2) i have the extra file that you were supposed to download after the upgrade to 2.0 installed as well

    so those aren't the problems.

  2. Kahil
    Member
    Posted 9 years ago #

    happened to both me and a friend... nothing was changed whatsoever... hmmm...

  3. vkaryl
    Member
    Posted 9 years ago #

    Have you checked with your hosts to see if they did anything - like an upgrade to something? An "errno" attached to a MySQL notation like that can sometimes be something you need to contact host support about....

  4. Kahil
    Member
    Posted 9 years ago #

    i have GoDaddy, you know what kind of support, or lack there of, they have...lol...

    but yeah, i tried and they didn't know jack shit...

    i tried to go in and delete all the tables with sk2 and re-install... no luck...

  5. klklaser
    Member
    Posted 9 years ago #

    This looks like the same message I've received. This is how I "fixed" it, but there may be a better way. Phpmyadmin reported the table as "in use", whatever that means, and it wouldn't repair.

    I emptied only the table wp_sk2_spams (I used phpmyadmin: I don't know the MySQL command line that correlates to). Note that the table wasn't "dropped" or "deleted", only "emptied", which retained its structure.

    That seemed to fix the database error. Then, I went and ran all recent comments back through all SK2 plugins.

  6. As noted, this is a host issue / database issue, not a SK2 one.

    Anyway, if you can repair, do it as that'll fix an error code of 145 99.9% of the time.

Topic Closed

This topic has been closed to new replies.

About this Topic