https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
--- Comment #29 from Bernardo Gonzalez Kriegel <[email protected]> --- Hi Jonathan, (In reply to Jonathan Druart from comment #27) > Bernardo, how did you generate new sample files? Mmmm, sorry but can't understand exactly... Just edited current files and fix what was needed (In reply to Jonathan Druart from comment #28) > What's the expected behavior if an error occurs, A) de-DE, es-ES, fr-CA and pl-PL, same error for all langs * first 3 patches applied * (cd misc/translator/; ./translate install de-DE) , for example * drop/create database, run webinstaller * marc21, select all sample data 1) web installer error Software error: [SQL ERROR]: -- ISSN: 1041-5653 -- Refer to http://www.niso.org/standards/index.html -- General Holdings: Type of Unit Designator INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','0','Information not available; Not applicable');INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','a','Basic bibliographic unit') For help 2) logs install.pl: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS' at line 5 at /usr/local/share/perl/5.18.2/DBIx/RunSQL.pm line 254... and more lines In this case I suppose that DBIx::RunSQL does not know how to parse 2 sql statments on the same line. B) fr-FR 1) web installer Software error: [SQL ERROR]: INSERT INTO `auth_types` (`authtypecode`, `authtypetext`, `auth_tag_to_report`, `summary`) VALUES ('','Défaut','','') 2) logs install.pl: DBD::mysql::st execute failed: Duplicate entry '' for key 'PRIMARY' at /usr/local/share/perl/5.18.2/DBIx/RunSQL.pm line 254. In this case as both autorite_default.sql and autorites_norme_unimarc.sql are 'Obligatoire', we have duplicate keys for 'Défaut' auth type and some other fields/subfields. Here the second file was edited to join all inserts in one statement (like EN marc21 files) instead of adding IGNORE to all INSERTs to prevent this error The other error is a space after final ';' on sample_labels.sql, similar to case A) -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
