[Koha] Empty list on Authorized Values after upgrade to 16.05.05

[Tajoli Zeno]

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 at cineca.it Fax: 051/6132198
*CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)