Spam Karma Crash

  • Resolved gilster

    (@gilster)


    19 years, 7 months ago

    I’ve used Spam Karma for well over a year with great success. But yesterday out of nowhere I found that it had stopped working. I get two error messages (full text below), the lead lines of which are “Failed to purge comment spam entries” and “Can’t fetch comments.”

    The upshot is that no comments go through to my weblog, spam or otherwise, though they do show up in my mailbox. Spam Karma has stopped working. Should I try the “Reset All Tables” button under “advanced options?” Or does anyone have a different solution?

    Thanks. Here’s the full text of the two error messages I get when trying to access Spam Karma’s features in the admin panel:

    Failed to purge comment spam entries.
    Query: DELETE wp_comments, wp_sk2_spams FROM wp_comments LEFT JOIN wp_sk2_spams ON wp_sk2_spams.comment_ID = wp_comments.comment_ID WHERE (wp_comments.comment_approved = ‘0’ OR wp_comments.comment_approved = ‘spam’) AND wp_comments.comment_date_gmt < DATE_SUB(‘2007-01-07 14:27:44’, INTERVAL 30 DAY)
    SQL error: Can’t open file: ‘wp_sk2_spams.MYI’ (errno: 144)

    And the other one 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.*, IF(comments_table.comment_approved = ‘0’, 1, 0) AS display_priority 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 display_priority DESC, comments_table.comment_date_gmt DESC LIMIT 20
    SQL error: Can’t open file: ‘wp_sk2_spams.MYI’ (errno: 144)

    I’m assuming this is a MySQL error but I don’t know how to proceed.

    Thanks for any help,

    Paul

Viewing 8 replies - 1 through 8 (of 8 total)
  • Chris_K

    (@handysolo)

    19 years, 7 months ago

    SQL error: Can’t open file: ‘wp_sk2_spams.MYI’ (errno: 144)

    That’s a MySQL error (errno: 144). You might want to contact your host.

    Thread Starter gilster

    (@gilster)

    19 years, 7 months ago

    I’ve got a support request in and am waiting on a response. I have no idea how to proceed if I need to repair something with phpMyAdmin, so I’m hoping the host may be able to handle it from there. Am also open to any other ideas or tips from those who see this. Is it difficult to repair a MySQL database?

    Chris_K

    (@handysolo)

    19 years, 7 months ago

    Log into phpMyAdmin.
    Select your database from the pulldown on the left.
    Click on the table giving errors.
    Click on the “Operations” tab.
    Towards the bottom is a “Repair table” link.

    Could give that a try, I reckon.

    Thread Starter gilster

    (@gilster)

    19 years, 7 months ago

    Thanks! I’ll see what my host company says as well, but what you’ve outlined above sounds like it’s worth a go. Much appreciated.

    Thread Starter gilster

    (@gilster)

    19 years, 7 months ago

    I’m also wondering about Spam Karma’s “Reset All Tables” button under “advanced options” in the menus. I would guess this would also re-do the MySQL file that’s causing the problem. Does anyone have any experience using this, and would it be preferable to trying to fix the problem through phpMyAdmin?

    Thread Starter gilster

    (@gilster)

    19 years, 7 months ago

    Problem — re your directions:

    Log into phpMyAdmin.
    Select your database from the pulldown on the left.
    Click on the table giving errors.
    Click on the “Operations” tab.
    Towards the bottom is a “Repair table” link.

    I get to the Operations tab (and phpMyAdmin does indeed say the table is broken), but there is no ‘repair table’ link. And I can’t find repair in the menu structure. Any ideas? Thanks!

    Chris_K

    (@handysolo)

    19 years, 7 months ago

    ok, small correction since you read minds about as well as I do… 😉

    Log into phpMyAdmin.
    Select your database from the pulldown on the left.
    Click the little “Browse icon” for the table giving you problems.
    Click on the “Operations” tab.
    Towards the bottom is a “Repair table” link.

    Thread Starter gilster

    (@gilster)

    19 years, 7 months ago

    Done. Sorry I didn’t get back to you sooner, but all is now well. I appreciate your help! Before I even had to implement the above, my hosting provider stepped in and fixed the table in question at my request. But I now know how to do it myself. Very useful!

    Paul

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Spam Karma Crash’ is closed to new replies.

Tags