Fix MySQL strict mode is not enabled in GLPi

MySQL strict mode is not enabled on GLPI debug mode

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

MySQL strict mode is not enabled on GLPI debug mode

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”

my.cnf add 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

  LLConecta #02: Diving into upcoming Gapp 2.8 with Lucas Levi (and my questionable Portuguese!)

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *

five + 17 =

Protected by Spam Master