Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_login'

[lix-dev]

Incorrect datetime value: '0000-00-00 00:00:00' for column 'last_login' at row 1 in /var/www/main/ftpadmin/includes/ez_sql_mysqli.php on line 272

After i updated my MySQL to 5.7.22

[bwulff]

A zero date(time) cannot be used anymore in MySQL 5.7+ (see STRICT_TRANS_TABLES, NO_ZERO_DATE).
An easy fix for the installation is to set the default date to '1970-01-01 00:00:01' but I suspect the application uses a zero date to indicate that the user never logged in. So this had to be changed.
The other option is to re-configure MySQL so that it doesn't run in strict mode.

[sunlix]

There are no checks inside the application. Just a default value for newly db entries.
I have fix that by set the most early supported datetime value. Without removing NO_ZERO_DATE.