ERROR db user: Incorrect datetime value: ’0000-00-00 00:00:00’ for column ’expiry’ at row 1
Article ID: 254 | Rating: Unrated | Last Updated: Tue, Feb 12, 2019 at 5:05 AM
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.