Fix MySQL strict mode is not enabled in GLPi

Updated

As stated by one of GLPI’s developers. This is not really an error message, but a warning for developers:

You should not enable strict mode; this may cause issues right now.

OK, this is my first post in English, so please don’t be mean, and take it as My Best Effort or a Yet Another Lousy IT Guy Doing His Best (YALIGDHB) :).

Let’s get our hands dirty. In my last GLPi upgrade to 0.90.1 had a permission issue I didn’t knew of. Because of this, I had Debug Mode activated and found this annoying warning message just in the middle of my lovely, new and responsive GLPi interface:

MySQL strict mode is not enabled

It wasn’t really that important. I didn’t want to have it all the time remind me of its existence, though.

mySQL mode STRICT_TRANS_TABLES

In order to remove it, you need to edit your my.cnf file. If using Debian plus vim :

sudo vim /etc/mysql/my.cnf
And add this simple line under [mysqld] section:

sql_mode = “STRICT_TRANS_TABLES”

And don’t forget to restart your mySQL!

service mysql restart

Do you need GLPi professional support? -> GLPi Professional Support