Title: WordPress database error Duplicate key name ‘datetime’
Last modified: October 13, 2017

---

# WordPress database error Duplicate key name ‘datetime’

 *  Resolved [orrevs](https://wordpress.org/support/users/orrevs/)
 * (@orrevs)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-key-name-datetime/)
 * Getting allot of this error
 * [13-Oct-2017 06:08:33 UTC] WordPress database error Duplicate key name ‘datetime’
   for query ALTER TABLE wp_iqblock_logging ADD KEY `datetime` (`datetime`) 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_upgrade, iqblockcountry_install_db,
   dbDelta
 * like every second on my site.

Viewing 1 replies (of 1 total)

 *  [mini](https://wordpress.org/support/users/bobmerquriusnl/)
 * (@bobmerquriusnl)
 * [8 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-key-name-datetime/#post-9630743)
 * I have about the same problem:
    WordPress database error You have an error in
   your SQL syntax; check the manual that corresponds to your MariaDB server version
   for the right syntax to use near ‘) >= datetime’ at line 1 for query DELETE FROM
   wp_petiqblock_logging WHERE DATE_SUB(CURDATE(),INTERVAL DAY) >= datetime; made
   by require_once(‘wp-admin/admin.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,
 * Errors started after updating the web-server:
    Apache 2.2.22 –> 2.4.25 php 5.4.45–
   > 7.0.19 MySQL Server 5.5.55 –> MariaDB Server 10.1.23

Viewing 1 replies (of 1 total)

The topic ‘WordPress database error Duplicate key name ‘datetime’’ 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/)

## Tags

 * [SQL syntax](https://wordpress.org/support/topic-tag/sql-syntax/)

 * 1 reply
 * 2 participants
 * Last reply from: [mini](https://wordpress.org/support/users/bobmerquriusnl/)
 * Last activity: [8 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-duplicate-key-name-datetime/#post-9630743)
 * Status: resolved