"Run selected entries through..." returns an SQL error

[xibe]

Steps to reproduce:

• Go to /wp-admin/edit-comments.php
• Click in the Apply button for SK's "Run selected entries through" tool (no need to change the settings).

Returns a white page with:

sk_comment: Cannot fetch comment record from table. SQL error: get_granularity: query failed. Query: SELECT COUNT(*) AS cmt_count, AVG(spams.karma) AS karma_avg FROM wp_comments AS comments LEFT JOIN wp_sk_spams AS spams ON spams.comment_ID = comments.comment_ID WHERE comments.comment_ID != AND comments.comment_approved = '1' AND comments.comment_date_gmt < DATE_SUB('', INTERVAL 3 DAY) AND comments.comment_author_IP = '' SQL error: sk_comment: Cannot fetch comment record from table. SQL error: Cannot update SK_SPAM_TABLE info (no comment ID provided).

Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxxxxxxx/blog/wp-content/plugins/spam-karma/spam_karma_plugin.php:45) in /home/xxxxxxxxxxx/blog/wp-includes/pluggable.php on line 1207

WordPress 4.3 Spam Karma 2.4-alpha-20150612

[strider72]

Does not reproduce on my machine. Will have to check further. xibe – Is this a fresh install of SK or updated from older?

[xibe]

Fresh install, in that I disabled SK2 (original plugin) and then uploaded and enabled spamkarma (from this repo). I do remember seeing SQL errors on install, sadly did it in a rush and forgot to take note. I'll try to reproduce on another install.

[strider72]

Possibly related to Issue #15 then.