MariaDB: Field 'nginx_directives' doesn't have a default value
short description
After upgrading MariaDB from 10.1 to 10.4 I experienced the SQL error "Field 'nginx_directives' doesn't have a default value" when trying to add/modify a web domain, alias domain... The problem is that that MariaDB changed SQL_MODE starting 10.2.4.
correct behaviour
No error.
environment
Server OS: Debian Server OS version: 9.0 Stretch with MariaDB 10.4.8 from the original MariaDB repositories (downloads.mariadb.com) ISPConfig version: 3.1.15p2
proposed fix
I first entered a default value for 'nginx_directives' in the table web_domain by allowing NULL as a default value. No idea if that is a correct default value. So I changed it back and fixed the problem by changing the default value of the SQL_MODE of MariaDB by leaving out STRICT_TRANS_TABLES.
In my eyes it would be good to have a default value for the field as STRICT_TRANS_TABLES is in the default value for SQL_MODE of MariaDB starting in 10.2.4 - so everybody will experience the problem after upgrading.