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

[Zeno Tajoli]

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