Spam Karma 2 unable to purge (1 post)

  1. garethjmsaunders
    Posted 8 years ago #

    I'm having a problem with Spam Karma 2 (2.2 Final). When I click the "Purge Comment Spams" under the "Recent Spam Harvest" tab I get the following error:

    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-13 18:50:12', INTERVAL 30 DAY)
    SQL error: You have an error in your SQL syntax near 'wp_comments, wp_sk2_spams FROM wp_comments LEFT JOIN wp_sk2_spams ON wp_' at line 1

    To be honest, I've never been able to get this to work so it's not that it has worked in the past and is now not working.

    I'm been into my PHPMyAdmin and performed maintenance (check, analyze, repair, optimize and flush) on the wp_sk2_spams table with no effect.

    I've also clicked the various buttons in the Advanced section of the Spam Karma 2 options (General Settings tab) with again nothing fixing the problem.

    Your advice would be gratefully received.


Topic Closed

This topic has been closed to new replies.

About this Topic