WPIntell

Source evidence

Database error recorded for every comment submitted

Spam Captcha – Safeguard your WordPress website effortlessly with Spam Captcha for WordPress · support · 2015-05-03T17:31:00+00:00

complaintsentiment
highseverity
1.0relevance
4replies
Evidence linked to opportunitycommercial context

Proof Health

Open evidence

Commercial opportunities need traceable source links before they are treated as build-worthy.

7 / 27 rows with source links

25.9% of this page's analysis has direct source links.

0 build-decision rows missing links

0 rows here require auditable proof before promotion.

20 rows with no attached evidence

0 rows have source counts but still need direct links.

Conversation

support
rowd1951 unresolved
Hello, I love your Spam Captcha plugin however every time a comment is submitted either successfully or not, I get the following error message: WordPress database error This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ for query DELETE FROM wp_pluginSL_spam_captcha WHERE id NOT IN (SELECT id FROM wp_pluginSL_spam_captcha ORDER BY date DESC LIMIT 10000) made by wp_new_comment, apply_filters(‘preprocess_comment’), call_user_func_array, spam_captcha->check_comment_captcha The plugin seems to work properly to me but obviously something is going wrong for this error to be recorded in the error log every single time, and has been for many many months, it isn’t a specific version of WP. Do you know what it might be? I completely uninstalled and reinstalled the plugin and it didn’t go away. Best wishes. https://wordpress.org/plugins/spam-captcha/ What is your MySQL version ? This command limits the number of log to 10000 … If you do not execute that command the size of the database could increase a lot Hi, my MySQL version is as follows: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.41-cll-lve – MySQL Community Server (GPL) Protocol version: 10 The Spam Captcha table in the database is empty because it is a fresh install (I’ve checked it in PHPMyAdmin just to be sure and yes, it is empty) yet the error log still shows this every time a comment (real or spam) is submitted. ok it seems that I have to found a way to avoid such issue… in the meanwhile you may comment (i.e. add // at the begining of the line containing “LIMIT 10000” in the spam-captch.php file Ok thanks, I have done that now and the error reports have stopped. (Obviously!)

Comments

4 shown
Sed Lex 2015-05-03T21:18:00+00:00

What is your MySQL version ? This command limits the number of log to 10000 … If you do not execute that command the size of the database could increase a lot

rowd1951 2015-05-03T22:39:00+00:00

Hi, my MySQL version is as follows: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.41-cll-lve – MySQL Community Server (GPL) Protocol version: 10 The Spam Captcha table in the database is empty because it is a fresh install (I’ve checked it in PHPMyAdmin just to be sure and yes, it is empty) yet the error log still shows this every time a comment (real or spam) is submitted.

Sed Lex 2015-05-05T10:07:00+00:00

ok it seems that I have to found a way to avoid such issue… in the meanwhile you may comment (i.e. add // at the begining of the line containing “LIMIT 10000” in the spam-captch.php file

rowd1951 2015-05-06T23:09:00+00:00

Ok thanks, I have done that now and the error reports have stopped. (Obviously!)