Test major Koha Wiki changes or bug fixes here without fear of breaking the production wiki.
For the current Koha Wiki, visit https://wiki.koha-community.org .DBMS configuration
The configuration of you Database Management System (DBMS) may need to be modified, depending on the versions of Koha you are using.
Since Ubuntu 16.04 (and others recent distros) the default configuration of the DBMS became more stricter
Since MySQL 5.7 and MariaDB 10.2.4, the default value for SQL modes is
MySQL:
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
MariaDB:
NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO
Since Koha 18.05.00, 17.11.05 or 17.05.11
Since Koha 18.05 (17.11.05 and 17.05.11) and bug 20229, it is no longer needed to modify the configuration.
Prior to Koha 18.05
Most of the versions of Koha (3.x, 16.05 to 17.11) are not compatible with this default configuration.
To bypasss the problem you can edit the configuration file (certainly /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf) and force the SQL modes Koha supports:
[mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
After save the changes and restart mysql.