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.
comment_approved= '0' OR
comment_approved= 'spam') AND
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
ONwp_' 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.