Hello Thank you very much, Zeno. Your solution worked. Regards Vasiliki Βασιλική Μελά Βιβλιοθηκονόμος *Αρχείο της ΕΡΤ* 210 609 2479 210 609 2431 210 606 6282 vmela@ert.gr On 18 December 2016 at 09:29, Zeno Tajoli <z.tajoli@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