1

Topic: Strict mode

I am getting an error about the strict mode in mysql

SQL strict modus niet volledig ingeschakeld, aangeraden voor development: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY,NO_AUTO_CREATE_USER

2

Re: Strict mode

Hello

What is your GLPI setup ? version / mysql / php ?

Yannick

Prod : GLPI 9.2 - Windows 2012 R2 - IIS 8.5 - Mariadb 10.1 - PHP 7.12 - Fusion 2.3.19
Certifié ITIL V3, PMP

3

Re: Strict mode

What don't you understand in the "for development" message ?

This mode have to be set for GLPI developer who want to work on MySQL 5.7 compatibility.

No change required for standard user (or whom don't understand the message)

Dév. Fedora 25 - PHP 5.4/5.5/5.6/7.0/7.1 - MariaDB 10.1 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/

4

Re: Strict mode

Ok so this wil not impact on regular users.

Thanks