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-5-7-strict-mode-back-to-how-it-was-in-5-6
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.taj...@cineca.it Fax: 051/6132198
*CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
