[Koha] Problem on Staged MARC management

[Pedro Amorim]

Hey,

Maybe. The following link reads *All version of Koha (3.x, 16.05, 16.11)
are not compatible with default config of MySQL 5.7* and provides a
solution:

https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7

We are currently using *mysql 5.6.26* and we have
*sql_mode=NO_ENGINE_SUBSTITUTION* in *my.cnf*.

I'm not sure if it's related but wouldn't hurt to try using mysql < 5.7,
given the documentation.

Pedro Amorim

2017-05-30 15:44 GMT+00:00 anjoze <joseanjos at gmail.com>:

> Olá Pedro,
>
> Yes I've tried other files.
> Trying with bulkmarcimport.pl I have this message:
>
> / bib-64150.marcxml
> <http://koha.1045719.n5.nabble.com/file/n5935220/bib-64150.marcxml>
> deleting biblios
> DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign
> key constraint (`koha_koha`.`aqorders`, CONSTRAINT `aqorders_ibfk_2`
> FOREIGN
> KEY (`biblionumber`) REFERENCES `koha_koha`.`biblio` (`biblionumber`)) [for
> Statement "truncate biblio"] at
> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 150.
> DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign
> key constraint (`koha_koha`.`items`, CONSTRAINT `items_ibfk_1` FOREIGN KEY
> (`biblioitemnumber`) REFERENCES `koha_koha`.`biblioitems`
> (`biblioitemnumber`)) [for Statement "truncate biblioitems"] at
> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 151.
> DBD::mysql::db do failed: Cannot truncate a table referenced in a foreign
> key constraint (`koha_koha`.`accountlines`, CONSTRAINT
> `accountlines_ibfk_2`
> FOREIGN KEY (`itemnumber`) REFERENCES `koha_koha`.`items` (`itemnumber`))
> [for Statement "truncate items"] at
> /usr/share/koha/bin/migration_tools/bulkmarcimport.pl line 152.
> Characteristic MARC flavour: UNIMARC
> .
> 1 MARC records done in 0.147950887680054 seconds/
>
> Maybe its a problem with Mysql 5.7? There was a lot of problems with mysql
> 5.7...
>
>
>
> -----
> Koha version:   16.05.05
>        - -
> José Anjos
> --
> View this message in context: http://koha.1045719.n5.nabble.
> com/Problem-on-Staged-MARC-management-tp5935206p5935220.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>