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
    Getting "Could not load configuration" or 500 error on login page
    Viewed 2730 times since Wed, Jun 14, 2017
    vi editor having issues while logged in via ezeelogin
    Viewed 1552 times since Wed, Jun 14, 2017
    setup web ssh console in ezeelogin and ssh via browser
    Viewed 6303 times since Tue, Jan 30, 2018
    no matching host key type found. Their offer: ssh-rsa,ssh-dss [preauth]
    Viewed 920 times since Mon, Jan 28, 2019
    no matching key exchange method found. Their offer: diffie-hellman-group1-sha1
    Viewed 3422 times since Tue, Jan 2, 2018
    Google Recaptcha shutdown issue
    Viewed 732 times since Tue, Jul 3, 2018
    User modify failed Cannot modify user on this node: Authentication by ssh key failed
    Viewed 3222 times since Wed, Jun 14, 2017
    Token not found in Cpanel/WHM
    Viewed 3840 times since Wed, Jun 14, 2017
    Unable to login into cpanel/whm with one click
    Viewed 3870 times since Wed, Jun 14, 2017
    404 error on login with nginx
    Viewed 2523 times since Wed, Jun 14, 2017