Title: Seeing PHP/Dateabase Errors?
Last modified: April 10, 2018

---

# Seeing PHP/Dateabase Errors?

 *  Resolved [eshera](https://wordpress.org/support/users/eshera/)
 * (@eshera)
 * [8 years ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/)
 * I am Seeing PHP/Dateabase Errors? – Any help would be greatly appreciated:
 * [https://plugintests.com/plugins/iq-block-country/latest](https://plugintests.com/plugins/iq-block-country/latest)
 * [04-Apr-2018 00:31:42 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_iqblock_logging
   WHERE `datetime` < DATE_SUB(NOW(), INTERVAL DAY) made by activate_plugin, include_once(‘/
   plugins/iq-block-country/iq-block-country.php’), iqblockcountry_clean_db
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fseeing-php-dateabase-errors%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  [capecross](https://wordpress.org/support/users/capecross/)
 * (@capecross)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/#post-10231444)
 * 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.
 *  Plugin Author [Pascal](https://wordpress.org/support/users/iqpascal/)
 * (@iqpascal)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/#post-10235746)
 * 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
 *  Plugin Author [Pascal](https://wordpress.org/support/users/iqpascal/)
 * (@iqpascal)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/#post-10300313)
 * 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.
 *  [capecross](https://wordpress.org/support/users/capecross/)
 * (@capecross)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/#post-10326299)
 * 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
 *  Plugin Author [Pascal](https://wordpress.org/support/users/iqpascal/)
 * (@iqpascal)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/#post-10326742)
 * 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.

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

The topic ‘Seeing PHP/Dateabase Errors?’ is closed to new replies.

 * ![](https://ps.w.org/iq-block-country/assets/icon-128x128.png?rev=3136019)
 * [iQ Block Country](https://wordpress.org/plugins/iq-block-country/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/iq-block-country/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/iq-block-country/)
 * [Active Topics](https://wordpress.org/support/plugin/iq-block-country/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/iq-block-country/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/iq-block-country/reviews/)

 * 5 replies
 * 3 participants
 * Last reply from: [Pascal](https://wordpress.org/support/users/iqpascal/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/seeing-php-dateabase-errors/#post-10326742)
 * Status: resolved