I'm having problems with getting Comments that are Spam and I try to delete them using Spam Karma 2 (isn't SK2 supposed to catch these already?) and I click the link in my email and get this message in my WP Admin:
sk2_comment: Cannot fetch comment record from table.
SQL error: Table 'tdc_wp.wp_sk2_spams' doesn't exist
get_comment_sk_info: Cannot get sk2_kSpamTable info (no comment ID provided).
Cannot add blacklist entry. Please fill in a value.
Failed to insert blacklist entry: ip_black - .
SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'score = 25' at line 1
Error: cannot update comment entry ID: 0 to status: spam.
SQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Cannot update sk2_kSpamTable info (no comment ID provided).
* General Settings
* Recent Spam Harvest
* Approved Comments
* Blacklist
* SK2 Logs
* About
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 AND (spam_table.karma IS NULL OR spam_table.karma >= -30) ORDER BY display_priority DESC, comments_table.comment_date_gmt DESC LIMIT 20
SQL error: Table 'tdc_wp.wp_sk2_spams' doesn't exist
