pure-ftp mariadb 10 PHP7.0 ftp_user expires doesn't get set to NULL
Similar to issue #3690 (closed) However, fix specified in 3690 does not correct the problem. MariaDB stores 0000-00-00 00:00:00 instead of NULL if "Expires At" in FTP Options GUI is changed, then blanked out (and saved). Initially, database expires column is NULL when the FTP user is created until a save causes it to change. Other than setting a date a long time in the future, as it stands, there is no way to fix this from the web page or know that it has happened. With 0000-00-00 00:00:00 in the expires column the FTP user will be expired.
As I just installed a new system, this took hours to find, many won't find it, and it will be very frustrating when the FTP login stops working for some unknown (but now we know) reason.
A proposed fix is to change "(expires IS NULL OR expires > NOW())" to "(expires = 0 OR expires IS NULL OR expires > NOW())" everywhere in /etc/pure-ftpd/db/mysql.conf