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
    Error: User add failed. Cannot add user on this node: FAILED: to establish SSH session
    Viewed 390 times since Thu, Sep 6, 2018
    How do i disable google 2 factor authentication or other 2factor mechanisms?
    Viewed 2850 times since Wed, Jun 14, 2017
    "An error occurred. Please contact administrator." - got error while trying to access remote server from jump server
    Viewed 653 times since Tue, May 8, 2018
    Token not found in Cpanel/WHM
    Viewed 2722 times since Wed, Jun 14, 2017
    Blank page when clicking add server
    Viewed 1283 times since Wed, Aug 16, 2017
    ’Failed to establish SSH session ’
    Viewed 871 times since Fri, Jun 22, 2018
    F1 - F4 keys not working in ezsh when using PuTTY
    Viewed 12937 times since Wed, Jun 14, 2017
    Unable to login into cpanel/whm with one click
    Viewed 3060 times since Wed, Jun 14, 2017
    error log file and configuration file to troubleshoot
    Viewed 1266 times since Thu, Jun 15, 2017
    Could not connect to database infinite loop on restore
    Viewed 2031 times since Wed, Jun 14, 2017