Seeing PHP/Dateabase Errors?

Hello,

Same error here too :

[30-Apr-2018 09:24:28 UTC] 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 ‘)’ at line 1 for query DELETE FROM wp_xxxxiqblock_logging WHERE datetime < DATE_SUB(NOW(), INTERVAL DAY); made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/iq-block-country/iq-block-country.php’), iqblockcountry_clean_db

WordPress 4.9.5
MySQL Database Version: 5.5.59-0+deb7u1-log
MySQL Client Version: 5.5.59
PHP Version: 7.2.3

Thanks for taking care.
Regards.

I will have to check on MySQL 5.5. I run MySQL 5.6 / 5.7 or MariaDB myself as MySQL 5.5 is already pretty old.

I do not see these errors myself

Can anyone that sees these errors set the “Number of days to keep logging:” to another amount of days on the iQ Block Country settings page?

The only way I can reproduce this if there is no interval given.

Hi,

Thanks for the suggestion.
By default it was set to 7 days. (i dont remember having changed this value).
I set it to 14 days, and the error is gone.
I did not try to go back to 7 days.
May be the initial (default) value was not taken in account correctly ?

Regards

Cool, thank you for the confirmation. Just what I thought ??

I already had a fix lined up so in next release this should not be an issue anymore.