pure-ftp mysql syntax error mysql 5.7
"0000-00-00 00:00" is the default value of the "ftp_user" . "expire" row. In newest mysql 5.7 it's not allowed to use this form, so inserting a new ftp user throws error.
ALTER TABLE ftp_user
CHANGE expires
expires
DATETIME NOT NULL DEFAULT '9999-12-31 23:59:59';
Mysql reference: The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.