29,131
edits
Changes
→SQL rules
Line 84:
Line 84:
To activate it (recommanded when developping on Dolibarr), add the following line into the config file of your Mysql server (my.cnf)
To activate it (recommanded when developping on Dolibarr), add the following line into the config file of your Mysql server (my.cnf)
<source lang="ini">
<source lang="ini">
−sql-mode="STRICT_ALL_TABLES"
+sql-mode="STRICT_ALL_TABLES,ONLY_FULL_GROUP_BY,NO_ZERO_DATE"
</source>
</source>