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.