[Bug 23353] New: Fresh installation duplicate keys ACQ-020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Bug ID: 23353 Summary: Fresh installation duplicate keys ACQ-020 Change sponsored?: --- Product: Koha Version: 19.05 Hardware: All OS: Linux Status: NEW Severity: blocker Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: mathben.informatique@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com I installed a fresh installation, Koha 19.05, with following this guide with Debian Stretch : https://wiki.koha-community.org/wiki/Debian Into my intra site, I use the web interface to configure the database. I use the default values and I get this error : " marc21_sample_acq_framework.sql [Mon Jul 22 03:04:19 2019] install.pl: DBD::mysql::st execute failed: Duplicate entry 'ACQ-020' for key 'PRIMARY' at /usr/share/perl5/DBIx/RunSQL.pm line 273. " The other SQL seems correctly installed. I used the translate fr-CA. I found the path of the SQL files : /usr/share/koha/intranet/cgi-bin/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_sample_acq_framework.sql When I continue the installation, I got this error from url "cgi-bin/koha/installer/onboarding.pl" : " Template process failed: file error - /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/fr-CA/modules/onboarding/onboardingstep1.tt: not found at /usr/share/koha/lib/C4/Templates.pm line 122. " -- 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=23353 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME CC| |tomascohen@gmail.com --- Comment #1 from Tomás Cohen Arazi <tomascohen@gmail.com> --- I cannot reproduce this bug. What I did: - Run: $ mkdir test_koha $ vagrant init debian/stretch64 $ vim Vagrantfile <uncommented the private_network thing> $ vagrant up $ vagrant ssh $ wget -q -O- https://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - $ echo 'deb http://debian.koha-community.org/koha 19.05 main' | sudo tee /etc/apt/sources.list.d/koha.list $ sudo apt update ; sudo apt install mysq-server koha-common $ sudo a2enmod rewrite $ sudo a2enmod cgi $ sudo systemctl restart apache2 $ sudo koha-create --create-db test $ sudo a2enmod headers proxy_http $ sudo systemctl restart apache2 $ sudo koha-plack --enable test $ sudo koah-plack --start test $ sudo koha-passwd test <copied the displayed password> - Tweaked my /etc/hosts adding 192.168.33.10 test-intra.myDNSname.org test.myDNSname.org - Pointed my browser to: http://test-intra.myDNSname.org - Used the instance credentials: koha_test / <the copied password> - Followed the steps, chose all the sample data => SUCCESS: No failures at all. -- 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=23353 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #2 from Tomás Cohen Arazi <tomascohen@gmail.com> --- I noticed this was about the fr-CA translation, and my tests fail on the very first step saying: Template process failed: file error - /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/fr-CA/modules/installer/step1.tt So, this is about the fr-CA translations! -- 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=23353 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |NEW Severity|blocker |major Summary|Fresh installation |ACQ framework makes fr-CA |duplicate keys ACQ-020 |web installer explode CC| |katrin.fischer@bsz-bw.de --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I have taken a look: http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mys... First it adds a copy of the default framework as the new ACQ framework with the first 3 INSERTS. Then the 4th tries to add a subset of the fields *again* which makes things explode. I didn't dare to just remove the one or the other set of INSERTS, because: - If you remove 4th and 5th the generated framework you have way too many fields visible if you decide to use the bibliographic part of it in ACQ (UseACQFrameworkForBiblioRecords) - If you remove the 2nd and 3rd, then you end up without 952 It appears that other installers don't have an ACQ framwork, at least I didn't spot one in en and de-DE. As a workaround for now: uncheck the ACQ framework from installing when you run the onboarding/web installer. Downgrading a bit, since the problem is limited and there is a workaoround. -- 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=23353 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #4 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Looks like it was this commit: http://git.koha-community.org/gitweb/?p=koha.git;a=commit;h=ad2b04001fe3100a... -- 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=23353 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Another note: 3 fr-CA files were amended - we only want one file to add the ACQ framework, not 3 :) -- 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=23353 --- Comment #6 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (In reply to Katrin Fischer from comment #5)
Another note: 3 fr-CA files were amended - we only want one file to add the ACQ framework, not 3 :)
Dismiss this comment, got confused by fr-FR and fr-CA and marcflavours. -- 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=23353 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED CC| |caroline.cyr-la-rose@inlibr | |o.com --- Comment #7 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- I will clean up the sql files for fr-CA -- 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=23353 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |caroline.cyr-la-rose@inlibr |ity.org |o.com -- 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=23353 Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Small patch Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 --- Comment #8 from Caroline Cyr La Rose <caroline.cyr-la-rose@inlibro.com> --- Created attachment 92297 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92297&action=edit Bug 23353: ACQ framework makes fr-CA web installer explode This patch removes the standalone ACQ framework SQL file in the fr-CA directory and adds the ACQ framework creation SQL in the default framework file, as it is in other languages. -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- 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=23353 Kyle M Hall <kyle@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #92297|0 |1 is obsolete| | --- Comment #9 from Kyle M Hall <kyle@bywatersolutions.com> --- Created attachment 92625 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92625&action=edit Bug 23353: ACQ framework makes fr-CA web installer explode This patch removes the standalone ACQ framework SQL file in the fr-CA directory and adds the ACQ framework creation SQL in the default framework file, as it is in other languages. Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- QA Contact|testopia@bugs.koha-communit |tomascohen@gmail.com |y.org | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Tomás Cohen Arazi <tomascohen@gmail.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=23353 Tomás Cohen Arazi <tomascohen@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #92625|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=23353 --- Comment #10 from Tomás Cohen Arazi <tomascohen@gmail.com> --- Created attachment 92653 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92653&action=edit Bug 23353: ACQ framework makes fr-CA web installer explode This patch removes the standalone ACQ framework SQL file in the fr-CA directory and adds the ACQ framework creation SQL in the default framework file, as it is in other languages. Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Martin Renvoize <martin.renvoize@ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |Pushed to master Version(s)| |19.11.00 released in| | -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 --- Comment #11 from Martin Renvoize <martin.renvoize@ptfs-europe.com> --- Nice work! Pushed to master for 19.11.00 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Pushed to master |Pushed to stable CC| |fridolin.somers@biblibre.co | |m Version(s)|19.11.00 |19.11.00,19.05.04 released in| | --- Comment #12 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Pushed to 19.05.x for 19.05.04 -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23353 Lucas Gass <lucas@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lucas@bywatersolutions.com --- Comment #13 from Lucas Gass <lucas@bywatersolutions.com> --- backported to 18.11.x for 18.11.11 -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org