error on step 3 (Unimarc - italian)
Hi everybody, I got an error while installing Koha package 3.22.07 (oldstable) with italian localization on Ubuntu 14.04.4 (MySQL 5.5.49). While creating default tables (unimarc_framework) the third step of installation procedure raise the error (see also attached file): unimarc_framework.sql [Thu Jun 9 23:20:14 2016] 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 `biblio_framework`(`frameworkcode`,`frameworktext`) values ('MN','M' at line 11 at /usr/share/perl5/DBIx/RunSQL.pm line 273 Whith the same configuration it is possible to install, without errors: Unimarc in english Marc21 in italian so I suppose the problem is connected with the italian localization. It looks like this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 but this bug is closed with the 3.22.07 that is exactly the package I'm using. If you have any idea it will be very much appreciated. thanks tommaso
Hi Tommaso, in this case the problem comes form line 7 of file installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql SET FOREIGN_KEY_CHECKS=0; There is a space at the end of the line, that space makes new Dbix::RunSQL module to fail :( This is addressed on Bug 16554 [1], for Italian and other languages. Try removing that ending space. Regards, Bernardo [1] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554 -- Bernardo Gonzalez Kriegel bgkriegel@gmail.com On Mon, Jun 13, 2016 at 10:06 AM, tommaso spazzali <spazzali@magritte.it> wrote:
Hi everybody,
I got an error while installing Koha package 3.22.07 (oldstable) with italian localization on Ubuntu 14.04.4 (MySQL 5.5.49).
While creating default tables (unimarc_framework) the third step of installation procedure raise the error (see also attached file):
unimarc_framework.sql [Thu Jun 9 23:20:14 2016] 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 `biblio_framework`(`frameworkcode`,`frameworktext`) values ('MN','M' at line 11 at /usr/share/perl5/DBIx/RunSQL.pm line 273
Whith the same configuration it is possible to install, without errors:
Unimarc in english Marc21 in italian
so I suppose the problem is connected with the italian localization.
It looks like this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
but this bug is closed with the 3.22.07 that is exactly the package I'm using.
If you have any idea it will be very much appreciated.
thanks tommaso
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
:) it works! thanks a lot (t) Il 14/06/2016 02:39, Bernardo Gonzalez Kriegel ha scritto:
Hi Tommaso, in this case the problem comes form line 7 of file installer/data/mysql/it-IT/marcflavour/unimarc/necessari/unimarc_framework.sql
SET FOREIGN_KEY_CHECKS=0;
There is a space at the end of the line, that space makes new Dbix::RunSQL module to fail :(
This is addressed on Bug 16554 [1], for Italian and other languages.
Try removing that ending space.
Regards, Bernardo
[1] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554
-- Bernardo Gonzalez Kriegel bgkriegel@gmail.com <mailto:bgkriegel@gmail.com>
On Mon, Jun 13, 2016 at 10:06 AM, tommaso spazzali <spazzali@magritte.it <mailto:spazzali@magritte.it>> wrote:
Hi everybody,
I got an error while installing Koha package 3.22.07 (oldstable) with italian localization on Ubuntu 14.04.4 (MySQL 5.5.49).
While creating default tables (unimarc_framework) the third step of installation procedure raise the error (see also attached file):
unimarc_framework.sql [Thu Jun 9 23:20:14 2016] install.pl <http://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 `biblio_framework`(`frameworkcode`,`frameworktext`) values ('MN','M' at line 11 at /usr/share/perl5/DBIx/RunSQL.pm line 273
Whith the same configuration it is possible to install, without errors:
Unimarc in english Marc21 in italian
so I suppose the problem is connected with the italian localization.
It looks like this: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
but this bug is closed with the 3.22.07 that is exactly the package I'm using.
If you have any idea it will be very much appreciated.
thanks tommaso
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tommaso Spazzali Magritte S.n.c. di Paolo Ferrarese & C. Via Meda, 25 20136 - Milano tel: +39.02-89408830 PGP Key: http://pgpkeys.mit.edu:11371/ I dati personali che ci avete fornito o che ci fornirete saranno oggetto di trattamento ai sensi del D. Lgs. 196/2003 attraverso strumenti idonei a garantirne la sicurezza, per le finalita' connesse ad attivita' commerciali nonche' di adempimento ad obblighi di legge. Il titolare del trattamento e' la societa' Magritte S.n.c.. Vi ricordiamo che potete esercitare i diritti di cui all’art. 7 del D. Lgs. 196/2003 consultabili sul sito del garante della Privacy: http://www.garanteprivacy.it
participants (2)
-
Bernardo Gonzalez Kriegel -
tommaso spazzali