SQL error

  • Resolved mishash

    (@mishash)


    6 years, 8 months ago

    Hi,
    After installing the plugin a couple of days ago, I noticed in the log the following errors:
    [Fri Mar 02 06:46:27.305851 2018] [fcgid:warn] [pid 22399] [client 24.232.170.6:34867] mod_fcgid: stderr: WordPress database 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 ‘) >= datetime’ at line 1 for query DELETE FROM wp_iqblock_logging WHERE DATE_SUB(CURDATE(),INTERVAL DAY) >= datetime; made by activate_plugin, include_once(‘/plugins/iq-block-country/iq-block-country.php’), iqblockcountry_clean_db, referer: https://www.example.com/blog/wp-admin/plugins.php

    I guess this is something to fix in the next version…
    Cheers,

    Mike

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Pascal

    (@iqpascal)

    I’ll check. I don’t believe I’ve seen these errors on my installations so far.

    Do you know which version of MySQL or MariaDB you are using? You should be able to find this on the Tools tab.

    Thread Starter mishash

    (@mishash)

    MySQL Database Version: 5.5.55-0ubuntu0.14.04.1
    MySQL Client Version: 5.5.55

    Plugin Author Pascal

    (@iqpascal)

    I have created a different SQL statement that perhaps works better with MySQL 5.5.x.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL error’ is closed to new replies.