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
    Could not connect to database infinite loop on restore
    Viewed 1825 times since Wed, Jun 14, 2017
    Can we map existing user group in ldap to ezeelogin as ezeelogin user group ?
    Viewed 2238 times since Mon, Sep 25, 2017
    Configure Automatic su or sudo
    Viewed 2166 times since Thu, Jun 15, 2017
    Could not setup Ezeelogin Web SSH service in ssh jumphost
    Viewed 483 times since Fri, Feb 16, 2018
    strange characters in the SSH logs recordings
    Viewed 1543 times since Thu, Jun 15, 2017
    Primary node showing the public ip instead of lan ip when cluster is configured
    Viewed 174 times since Wed, Nov 21, 2018
    Jump server ip to be licensed?
    Viewed 1483 times since Thu, Jun 15, 2017
    Disabling reCAPTCHA
    Viewed 1255 times since Wed, Jun 14, 2017
    How to disable web terminal appllication in Cpanel ?
    Viewed 829 times since Fri, Jun 29, 2018
    ALERT: REMOTE HOST IDENTIFICATION HAS CHANGED! Contact Administrator.
    Viewed 1448 times since Wed, Jun 14, 2017