[Bug 17860] New: MARC records will stage, but Manage for import shows ' no data in table'
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Bug ID: 17860 Summary: MARC records will stage, but Manage for import shows 'no data in table' Change sponsored?: --- Product: Koha Version: 16.11 Hardware: PC OS: Linux Status: NEW Severity: major Priority: P5 - low Component: MARC Bibliographic record staging/import Assignee: gmcharlt@gmail.com Reporter: gale@rabbat.net QA Contact: testopia@bugs.koha-community.org I have no difficulty staging bibliographic or authority records, but using management, yields 'no data in table'. Have tried the files on demo systems and they work. Don't understand what the trouble is. Have deleted and reinstalled Koha, have dumped mysql data and recreated database. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 gale@rabbat.net <gale@rabbat.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - low |P1 - high -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 --- Comment #1 from gale@rabbat.net <gale@rabbat.net> --- Created attachment 58653 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=58653&action=edit error log produced after attempt to stage and manage MARC records -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 gale@rabbat.net <gale@rabbat.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |gale@rabbat.net -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org Blocks| |17258 --- Comment #2 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Hello, The relevant message is "stage-marc-import.pl: DBD::mysql::st execute failed: Field 'marcxml_old' doesn't have a default value". Indeed we have a sql query inserting a row in the import_records without specifying a value for this marcxml_old column (C4/ImportBatch.pm:1560 in _create_import_record). Take a look at this entry on the wiki page to know how to fix this problem: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_... Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMIBUS] MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|16.11 |unspecified Severity|major |normal -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 niko <schachne@th-brandenburg.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |schachne@th-brandenburg.de --- Comment #3 from niko <schachne@th-brandenburg.de> --- Hi there, it seems that i have exactly the same problem here. 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/tools/stage-marc-import.pl, referer: http://localhost:8080/cgi-bin/koha/tools/stage-marc-import. I am using MariaDB and I am quite a newbie. I am not able to locate the right file in MariaDB to add sql-mode="IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" nor I am sure it is necessary in MariaDB. Can You give me a hint, please... -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 --- Comment #4 from niko <schachne@th-brandenburg.de> --- to be more specific about my test-Installation: Ubuntu-16.04 Koha version: 17.05.06.000 MySQL version: mysql Ver 15.1 Distrib 10.2.11-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 niko <schachne@th-brandenburg.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #5 from niko <schachne@th-brandenburg.de> --- found it: /etc/mysql/conf.d/mariadb.cnf restarted the mysq-server. now it works. the documentation here implies that this problem is not present with MariaDB. This seems to be wrong!? -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to niko from comment #5)
found it: /etc/mysql/conf.d/mariadb.cnf restarted the mysq-server.
now it works.
the documentation here implies that this problem is not present with MariaDB. This seems to be wrong!?
Indeed, https://mariadb.com/kb/en/library/sql-mode/: """ Since MariaDB 10.2.4, SQL_MODE is by default set to NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO. In earlier versions of MariaDB 10.2, and since MariaDB 10.1.7, SQL_MODE is by default set to NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER. For earlier versions of MariaDB 10.1, and MariaDB 10.0 and before, no default is set. """ -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|FIXED |--- Summary|MARC records will stage, |[SQL strict mode] MARC |but Manage for import shows |records will stage, but |'no data in table' |Manage for import shows 'no | |data in table' Status|RESOLVED |REOPENED -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEW -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17860 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #7 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Will be fixed by bug 20144 *** This bug has been marked as a duplicate of bug 20144 *** -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org