ERROR db user: Incorrect datetime value: ’0000-00-00 00:00:00’ for column ’expiry’ at row 1

Got this error while upgrade "ERROR db user: Incorrect datetime value: '0000-00-00 00:00:00' for column 'expiry' at row 1 "


1. Execute the following query on mysql server before upgrade. You can find the Database logins from /usr/local/etc/ezlogin/ez.conf file.


update db_prefix_users set `expiry`=NULL where `expiry`='0000-00-00 00:00:00'; 

    Replace the db_prefix with value of db_prefix from  /usr/local/etc/ezlogin/ez.conf file.


2. You can also upgrade ezeelogin after disabling MySQL strict mode.







0 (0)
Article Rating (No Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    Switching node states in Ezeelogin Cluster
    Viewed 274 times since Sat, Jan 2, 2021
    Viewed 489 times since Sat, Nov 7, 2020
    mysqli::real_connect(): this stream does not support SSL/crypto Filename: mysqli/mysqli_driver.php
    Viewed 2211 times since Tue, Jan 7, 2020
    502 on login with nginx
    Viewed 4956 times since Wed, Jun 14, 2017
    User add failed: Error waiting for connection: Cannot add user on this node: Could not connect
    Viewed 2639 times since Wed, Jun 14, 2017
    sshd[3167]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
    Viewed 3694 times since Mon, Apr 27, 2020
    ssh session slow and not responsive
    Viewed 2985 times since Thu, Jun 15, 2017
    PHP Fatal error: The file /usr/local/sbin/backup_ezlogin.php was encoded by the ionCube Encoder for PHP. Ioncube Encoder Error during Ezeelogin upgrade
    Viewed 1590 times since Tue, Jul 24, 2018
    Unable to open ssh session
    Viewed 3364 times since Thu, Jun 15, 2017
    ’Failed to establish SSH session ’
    Viewed 3720 times since Fri, Jun 22, 2018