• 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

  • The topic ‘SQL Errors with Spam Karma 2’ is closed to new replies.