Hi, Il 11/11/2016 16:21, anjoze ha scritto:
Until now, the only problem reported by my librarians colleges is when making a reservation for a patron. The result is: Software error:
DBIx::Class::Storage::DBI::_dbh_execute(): Field 'lowestPriority' doesn't have a default value at /usr/share/koha/lib/Koha/Object.pm line 109
in fact is possible an other problem connect with MySQL 5.7. Try to insert in your /etc/mysql/my.conf: [mysqld] sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Source: http://askubuntu.com/questions/811831/whats-the-correct-way-to-revert-mysql-... This is the same mode in mysql 5.6. If it doesn't work, try: [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION Every time restart mysql daemon. ATTENTION !! Be careful. I don't test those instructions so I don't know if they could create problems instead of resolve them. Test them before in spare server. Bye Zeno Tajoli -- Zeno Tajoli /SVILUPPO PRODOTTI CINECA/ - Automazione Biblioteche Email: z.tajoli@cineca.it Fax: 051/6132198 *CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)