Change MySQL Strict Mode

[aaronbrad]

If MysQL mode is in strict and some commands aren't going through. This mode enforces very explicit restrictions on the data and format of data that goes into the table columns

To turn off strict mode in MySQL, edit the my.ini or my.cnf file

change the sql-mode line to:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[hoststud]

You can edit my.cnf or also you can do this from PHPMyadmin.
You can check steps to edit my.cnf here (https://hoststud.com/threads/steps-to-disable-mysql-strict-mode.445/).