Skip to Content

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.