Tutorial Disable strict mode on MariaDB

[DevOps]

• MySQL and MariaDB have been diverging since 2010, and now they should be considered different software products (sort of like Microsoft SQL server vs. Sybase). You should tell us which one you use, and tag your question appropriately. The answer to your question will be different depending on which one you are using.
• You should read mariadb.com/kb/en/library/set including: "Changing a system variable by using the SET statement does not make the change permanently. To do so, the change must be made in a configuration file." You can't do this from the phpmyadmin user interface. You have to edit the configuration file on the MariaDB server

Edit via SSH

/etc/my.cnf file

Add

sql_mode=NO_ENGINE_SUBSTITUTION

restart MariaDB

and it will fix the issue

*edit - if You have error while restarting msyql service try to add "[mysqld]" above in my.cnf