[Koha] Z39.50 search - "Nothing found"

[Vasiliki Mela]

Hello

Thank you very much, Zeno. Your solution worked.

Regards
Vasiliki

Βασιλική Μελά
Βιβλιοθηκονόμος
*Αρχείο της ΕΡΤ*

210 609 2479
210 609 2431
210 606 6282
vmela at ert.gr

On 18 December 2016 at 09:29, Zeno Tajoli <z.tajoli at cineca.it> wrote:

> Hi all,
>
> this the relevant issue:
> >*z3950_search.pl <http://z3950_search.pl>: DBD::mysql::st execute failed:
> >Field 'marcxml_old'*
> >*doesn't have a default value* [for Statement "INSERT INTO
> >import_records (import_batch_id, record_sequence, marc, marcxml, :
> >/usr/share/koha/intranet/cgi-bin/cataloguing/z3950_search.pl, referer:
>
> reading those lines is more clear:
>
> >Description:    Ubuntu 16.04.1 LTS
> >*Koha version:*  16.05.03.000
> >mysql Ver 14.14 Distrib 5.7.16, for Linux (x86_64) using EditLine wrapper
>
> Now Koha 16.05 and 16.11 don't support MySQL 5.7
> https://koha-community.org/koha-16-05-released/
>
> 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
>
>
> ATTENTION !! Be careful. I don't test those instructions.
> so I don't know if they could create problems instead of resolve them.
> An other user use them and he report an OK
>
> Test them before in spare server.
>
> See:
> https://lists.katipo.co.nz/pipermail/koha/2016-November/046591.html
> https://lists.katipo.co.nz/pipermail/koha/2016-November/046596.html
>
> Bye
> Zeno Tajoli
>
>
>
>
>
>