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.

See also

bug 17258

MariaDB sql-mode

MySQL sql-mode