Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
xibe opened this issue Aug 19, 2015 · 3 comments
Open

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

xibe opened this issue Aug 19, 2015 · 3 comments

Comments

@xibe
Copy link
Collaborator

xibe commented Aug 19, 2015

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
Copy link
Owner

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

@xibe
Copy link
Collaborator Author

xibe commented Aug 19, 2015

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
Copy link
Owner

Possibly related to Issue #15 then.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants