Fix SQL no default value for columns errors: NO_ENGINE_SUBSTITUTION

In /etc/mysql/my.cnf:

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

This was the old one (or you can just delete it to restore to default):

sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION