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
    License cache outdated but its not time yet
    Viewed 1513 times since Wed, Jun 14, 2017
    Connection has been closed. Another user may have logged in on the remote windows machine
    Viewed 1983 times since Thu, Jun 15, 2017
    Can’t connect to local MySQL server through socket /tmp/mysql.sock
    Viewed 3533 times since Thu, Jun 15, 2017
    no matching key exchange method found. Their offer: diffie-hellman-group1-sha1
    Viewed 2961 times since Tue, Jan 2, 2018
    web interface very slow to load
    Viewed 461 times since Wed, Sep 19, 2018
    In parallel shell i get "An error occurred. Please contact administrator"
    Viewed 2629 times since Wed, Jun 14, 2017
    F1 - F4 keys not working in ezsh when using PuTTY
    Viewed 16042 times since Wed, Jun 14, 2017
    Why does the ssh log have control characters and looks different from the actual input?
    Viewed 1774 times since Thu, Jun 15, 2017
    Disabling reCAPTCHA
    Viewed 1714 times since Wed, Jun 14, 2017
    User could not be found on the system:: No error information
    Viewed 249 times since Thu, May 30, 2019