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 <[email protected]>: > 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 > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
