Error Laravel after MariaDB updated

Hi inventdigital,

I had two cases wherein I moved a website to a newly setup Interworx server and then that website wasn’t working properly, no values were being written, turns out that Mariadb’s sql_mode defaults to strict.

Ex: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Can just set it to none

in /etc/my.cnf

Add: sql_mode=""

then restart mysql

After I did that, the websites worked.

1 Like