WordPress database error: [BIGINT UNSIGNED

  • Resolved VidYen, LLC

    (@vidyen)


    6 years, 1 month ago

    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 www.remarpro.com repository, but no change.

    The int for the ctime is 10 but i didn’t mess with it.

    Thanks.

    • This topic was modified 6 years, 1 month ago by VidYen, LLC.
    • This topic was modified 6 years, 1 month ago by VidYen, LLC.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfphil

    (@wfphil)

    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

    (@wfphil)

    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.

Tags