Hi,

After some attempts I've edited */etc/mysql/my.conf* and inserted this 2 lines at bottom: * [mysqld] sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"*

It looks everything ok and the authorized vales lists are showing.

can you write the exact version of MySQL on your server and your Linux distro ? Bye Zeno Tajoli

Hi Aanjoze Il 11/11/2016 10:10, anjoze ha scritto:

SHOW VARIABLES LIKE "%version%"; | version | 5.7.16-0ubuntu0.16.04.1 |

your server is an Ubuntu 16.04 LTS (Xenial Xerus) with mysql 5.7 In Koha 16.05 this version of MySQL is not supported See this bus and its 'Depends on' bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 I'm quite sure that your modification on /etc/mysql/my.conf:

and inserted this 2 lines at bottom:

[mysqld] sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"*

it is a good mitigation fix. Test your installation as much as you can and write here: -- The tests have you done. -- The results have you find. Try to test every aspects onIntranet (cataloguing, loans, acquistions, tools, etc) and on Opac (search, do an hold, display of items status, list, cart, etc.) In fact this problem is not only about Authorized Values. 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)

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)