Database error recorded for every comment submitted

  • 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://www.ads-software.com/plugins/spam-captcha/

Viewing 4 replies - 1 through 4 (of 4 total)

  • 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

    Thread Starter rowd1951

    (@rowd1951)

    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

    Thread Starter rowd1951

    (@rowd1951)

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database error recorded for every comment submitted’ is closed to new replies.