SQL Errors with Spam Karma 2
-
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
* AboutCan’t fetch comments.
Query: SELECTposts_table
.post_title
,spam_table
.karma
,spam_table
.id
asspam_id
,spam_table
.karma_cmts
,comments_table
.*, IF(comments_table
.comment_approved
= ‘0’, 1, 0) ASdisplay_priority
FROM (wp_comments
AScomments_table
,wp_posts
ASposts_table
) LEFT JOINwp_sk2_spams
ASspam_table
ONspam_table
.comment_ID
=comments_table
.comment_ID
WHEREcomment_approved
!= ‘1’ ANDposts_table
.ID
=comments_table
.comment_post_ID
AND (spam_table
.karma
IS NULL ORspam_table
.karma
>= -30) ORDER BYdisplay_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.