May 2016 - Koha-bugs - lists.koha-community.org

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51612|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51611|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #29 from Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> --- 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.

1 0

[Bug 15399] MARCXML records larger than 1 MB (1048576 bytes) are not searchable.
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15399 Lari Taskula <larit(a)student.uef.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |larit(a)student.uef.fi -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #28 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- What's the expected behavior if an error occurs, -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #27 from Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> --- Bernardo, how did you generate new sample files? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #51610|0 |1 is obsolete| | --- Comment #26 from Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> --- Created attachment 51612 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51612&action=ed… Bug 13669: (followup) fix I18N files This patch fix web installer for de-DE, es-ES, fr-CA, nb-NO and pl-PL To test: 1) Apply patch 2) Try web installer for any/all listed languages. a) de-DE, es-ES, fr-CA and pl-PL There must be no problems for marc21 + all sample files b) nb-NO There must be no problems for normarc + all sample files Fixed test plan -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Needs Signoff CC| |bgkriegel(a)gmail.com --- Comment #25 from Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> --- (In reply to Chris Cormack from comment #20) > It works, but a new dependency eh? We need to update that too. > > I've attached it as a signed off patch, but will let the RM and others > decide if they want to add the new dependency. You are right, but SQL::SplitStatement also needs packaging. Tested web installer in all languages, added fixes for almost all. ru-RU and uk-UA need more work, but I need to sleep. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #24 from Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> --- Created attachment 51611 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51611&action=ed… Bug 13669: (followup) fix fr-FR files Rewrite autorites_norme_unimarc.sql to use only one INSERT IGNORE. New load method complains about duplicate keys, and both auth files are mandatory! Also removed an exotic blank space on sample_labels.sql Tested with unimarc_complet and all sample files. To test 1) Apply the patch 2) Try fr-FR web installer, unimarc_complet + all sample files There must be no errors Don't know if fr-FR marc21 and unimarc_lecture_pub are used, need a look from french users. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13669] Web installer fails to load sample data on MySQL 5.6+
by bugzilla-daemon＠bugs.koha-community.org 19 May '16

19 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 --- Comment #23 from Bernardo Gonzalez Kriegel <bgkriegel(a)gmail.com> --- Created attachment 51610 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51610&action=ed… Bug 13669: (followup) fix I18N files This patch fix web installer for de-DE, es-ES, fr-CA, nb-NO and pl-PL To test: 1) Apply patch 2) Try web installer for any/all listed languages. There must be no problems for marc21 + all sample files -- You are receiving this mail because: You are watching all bug changes.

1 0