[Bug 26612] New: Error during web install for it-IT translation
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Bug ID: 26612 Summary: Error during web install for it-IT translation Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: john@voipsupport.it QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Created attachment 111257 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=111257&action=edit patch When running the web installer with it-IT translation, the Unimarc version of unimarc_framework.sql gives an error about the record with key 307 violating null constraint. Sorry I did not keep the exact error message. However, the install does not proceed beyond inserting record 306 and the installation must be restarted after correcting the unimarc_framework.sql file. The patch to the file is attached. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi John, looking at that file it's only a diff and not a real patch file, missing the headers needed to be applied with our tools. Could you maybe redo it using git format-patch as described here? https://wiki.koha-community.org/wiki/Version_Control_Using_Git#Share_with_th... You also might have to set up some configuration in git to put out your name and email correctly: https://wiki.koha-community.org/wiki/Version_Control_Using_Git#Fill_some_par... Please let us know if we can help. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED CC| |jonathan.druart@bugs.koha-c | |ommunity.org Assignee|koha-bugs@lists.koha-commun |john@voipsupport.it |ity.org | Severity|enhancement |normal Version|20.05 |master -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |rel_20_11_target -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 John Fawcett <john@voipsupport.it> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #111257|0 |1 is obsolete| | --- Comment #2 from John Fawcett <john@voipsupport.it> --- Created attachment 111510 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=111510&action=edit patch for 26612 resubmitting patch using git format-patch -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- This is ready for testing, adjusting status. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Trivial patch Status|Needs Signoff |Signed Off -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 111823 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=111823&action=edit Bug 26612: Error during web install for it-IT translation Patch changes some of the values in the sql statement that inserts 307a unimarc row into the marc_subfield_structure which created an SQL error on installation. The fields changed are: - isurl now 0 instead of NULL, - hidden now -5 instead of NULL, - seealso empty string instead of NULL, - link empty string instead of NULL. These field values are now similar to the ones inserted for 306a or 308a. The value that caused the SQL error was using NULL for hidden (due to the NOT NULL constraint in the table definition). I have tested the install with this change and found no issues. Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |julian.maurice@biblibre.com Attachment #111510|0 |1 is obsolete| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #111823|0 |1 is obsolete| | --- Comment #5 from Julian Maurice <julian.maurice@biblibre.com> --- Created attachment 111832 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=111832&action=edit Bug 26612: Error during web install for it-IT translation Patch changes some of the values in the sql statement that inserts 307a unimarc row into the marc_subfield_structure which created an SQL error on installation. The fields changed are: - isurl now 0 instead of NULL, - hidden now -5 instead of NULL, - seealso empty string instead of NULL, - link empty string instead of NULL. These field values are now similar to the ones inserted for 306a or 308a. The value that caused the SQL error was using NULL for hidden (due to the NOT NULL constraint in the table definition). I have tested the install with this change and found no issues. Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> Signed-off-by: Julian Maurice <julian.maurice@biblibre.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Julian Maurice <julian.maurice@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Passed QA -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Thx, Julian! And I believe this will be John's first patches in Koha, congrats! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)| |20.11.00 released in| | Status|Passed QA |Pushed to master -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 --- Comment #7 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Pushed to master for 20.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 --- Comment #8 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Congratulations John for your first patch pushed! -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords|rel_20_11_target | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)|20.11.00 |20.11.00, 20.05.06 released in| | CC| |lucas@bywatersolutions.com Status|Pushed to master |Pushed to stable --- Comment #9 from Lucas Gass <lucas@bywatersolutions.com> --- backported to 20.05.x for 20.05.06 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Aleisha Amohia <aleisha@catalyst.net.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- Version(s)|20.11.00, 20.05.06 |20.11.00, 20.05.06, released in| |19.11.12 CC| |aleisha@catalyst.net.nz Status|Pushed to stable |Pushed to oldstable --- Comment #10 from Aleisha Amohia <aleisha@catalyst.net.nz> --- backported to 19.11.x for 19.11.12 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26612 Victor Grousset/tuxayo <victor@tuxayo.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |victor@tuxayo.net Version(s)|20.11.00, 20.05.06, |20.11.00, 20.05.06, released in|19.11.12 |19.11.12, 19.05.17 Status|Pushed to oldstable |Pushed to oldoldstable --- Comment #11 from Victor Grousset/tuxayo <victor@tuxayo.net> --- Backported to 19.05.x branch for 19.05.17 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org