Empty list on Authorized Values after upgrade to 16.05.05

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Empty list on Authorized Values after upgrade to 16.05.05

anjoze
After upgrading I've lost the Authorized values on MARC frameworks.
The parameters on each framework are ok (ex: Auth value:Country) but, when cataloging (editing or creating new record), the list is blank.
Searched for bugs but can't find it...
Thanks for any help
Koha version: 16.05.05
       - -
José Anjos
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

anjoze
I've added &debug=1 to the address line to get more debugging info
In /var/log/koha/koha/intranet-error.log i've found this:

DBD::mysql::st execute failed: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'koha_koha.authorised_values.authorised_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [for Statement "SELECT authorised_value, lib: /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl

Is this the problem?
I've changed sql_mode to SET sql_mode=''; but problem persists.
Koha version: 16.05.05
       - -
José Anjos
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

anjoze
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.
Koha version: 16.05.05
       - -
José Anjos
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

Zeno Tajoli-2
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
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

anjoze

SHOW VARIABLES LIKE "%version%";

| innodb_version          | 5.7.16                  |
| protocol_version        | 10                      |
| slave_type_conversions  |                         |
| tls_version             | TLSv1,TLSv1.1           |
| version                 | 5.7.16-0ubuntu0.16.04.1 |
| version_comment         | (Ubuntu)                |
| version_compile_machine | x86_64                  |
| version_compile_os      | Linux

uname -a
Linux 4.4.0-47-generic #68-Ubuntu SMP Wed Oct 26 19:39:52 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

Perl: 5.022001
Perl @INC: /usr/share/koha/lib
/etc/perl
/usr/local/lib/x86_64-linux-gnu/perl/5.22.1
/usr/local/share/perl/5.22.1
/usr/lib/x86_64-linux-gnu/perl5/5.22
/usr/share/perl5
/usr/lib/x86_64-linux-gnu/perl/5.22
/usr/share/perl/5.22
/usr/local/lib/site_perl
/usr/lib/x86_64-linux-gnu/perl-base

 Apache: Server version: Apache/2.4.18 (Ubuntu)
Koha version: 16.05.05
       - -
José Anjos
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

Zeno Tajoli-2
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: [hidden email] Fax: 051/6132198
*CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

anjoze
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

and no reservation is done.
Koha version: 16.05.05
       - -
José Anjos
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

Zeno Tajoli-2
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: [hidden email] Fax: 051/6132198
*CINECA* Consorzio Interuniversitario - Sede operativa di Segrate (MI)
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: Empty list on Authorized Values after upgrade to 16.05.05

anjoze
Hi Zeno,

It works with:
[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Now I can make reservations :)
I will post any feedback from librarians if something fails.
Thank you
Koha version: 16.05.05
       - -
José Anjos