The only way I’ve got this to work is by changing the docker command:
# ------------------------------------------------------------
# MySQL Database
# ------------------------------------------------------------
mysql:
image: devilbox/mysql:${MYSQL_SERVER}
hostname: mysql
# Set sql mode manually
command: mysqld --sql_mode=""
Tried changing the mysql_mode in devilbox/cfg/mariadb-10.3/devilbox-custom.cnf but for some reason it has no effect, any ideas why?
[mysqld]
;key_buffer_size=16M
sql_mode = ""
[mysqldump]
;quick