Title: WordPress database error: [BIGINT UNSIGNED
Last modified: February 5, 2019

---

# WordPress database error: [BIGINT UNSIGNED

 *  Resolved [VidYen, LLC](https://wordpress.org/support/users/vidyen/)
 * (@vidyen)
 * [7 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-bigint-unsigned/)
 * Hello,
 * On the firewall dashboard I am getting the following error:
 *     ```
       Warning: mysqli_query(): (22003/1690): BIGINT UNSIGNED value is out of range in '(unix_timestamp() - <code>cpanel_wp017</code>.<code>wp54_wflocs</code>.<code>ctime</code>)' in /home/cpanel/public_html/wp-includes/wp-db.php on line 1924
       WordPress database error: [BIGINT UNSIGNED value is out of range in '(unix_timestamp() - <code>vcpanel_wp017</code>.<code>wp54_wflocs</code>.<code>ctime</code>)']
       ```
   
 * In phpAdmin, I checked and the wflocs table is there and is apparently adding
   items and functioning as far as reporting of blocked IPs.
 * In the WordFence diagnostics everything is green and listed as ok under MySQL
 * MySQL version is 5.7.25 and I use PHP version 7.2.14
 * I uninstalled WordFence and reinstalled via the WordPress.org repository, but
   no change.
 * The int for the ctime is 10 but i didn’t mess with it.
 * Thanks.
    -  This topic was modified 7 years, 4 months ago by [VidYen, LLC](https://wordpress.org/support/users/vidyen/).
    -  This topic was modified 7 years, 4 months ago by [VidYen, LLC](https://wordpress.org/support/users/vidyen/).

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

 *  Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/)
 * (@wfphil)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-bigint-unsigned/#post-11206635)
 * Hi,
 * Our best guess is that the database server had its clock set incorrectly for 
   a while, or the site was migrated from another host where the clock was set incorrectly.
 * You can export your Wordfence settings on the **_Tools_** page.
 * Then enable the option **_Delete Wordfence tables and data on deactivation_**.
 * Deactivate and activate Wordfence from the WordPress **_Plugins_** page.
 * You will need to optimize the firewall and run through the firewall **_Learning
   Mode_** process again .
 * Let me know if that resolves it.
 *  Plugin Support [wfphil](https://wordpress.org/support/users/wfphil/)
 * (@wfphil)
 * [7 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-bigint-unsigned/#post-11254823)
 * Hi,
 * Since I haven’t heard back from you I am assuming that the instructions solved
   your issue so I am marking this topic as resolved.
 * If however, for whatever reason, you are still experiencing this issue and it
   is not resolved please respond to the post, which moves it back up the queue,
   and mark this topic as “not resolved”.
 * Thank you.

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

The topic ‘WordPress database error: [BIGINT UNSIGNED’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

## Tags

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

 * 2 replies
 * 2 participants
 * Last reply from: [wfphil](https://wordpress.org/support/users/wfphil/)
 * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/wordpress-database-error-bigint-unsigned/#post-11254823)
 * Status: resolved