https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554 --- Comment #54 from M. Tompsett <mtompset@hotmail.com> --- (In reply to Jonathan Druart from comment #51)
Still fails, even with gzip files: # 21/26: /home/koha/src/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/ Obligatoire/autorite_default.sql C4::Installer::load_sql returned the following errors while attempting to load /home/koha/src/installer/data/mysql/fr-FR/marcflavour/un imarc_complet/Obligatoire/autorites_norme_unimarc.sql: not ok 1 - /home/koha/src/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/ Obligatoire/autorites_norme_unimarc.sql: DBD::mysql::s t execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_test_installer`.`auth_subfield_structure`, CO NSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UP DATE C) at /usr/local/share/perl/5.22.1/DBIx/RunSQL.pm line 254. # # Failed test '/home/koha/src/installer/data/mysql/fr-FR/marcflavour/unimarc_complet/ Obligatoire/autorites_norme_unimarc.sql: DBD::my sql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_test_installer`.`auth_subfield_structur e`, CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE C) at /usr/local/share/perl/5.22.1/DBIx/RunSQL.pm line 254. # ' # at t/db_dependent/Test_installer.t line 48.
OH! I think I have it. If you recall ALTER IGNORE doesn't work in MySQL 5.7.4, so if you upgraded through 3.19.00.042, you may find the upgrade had issues. I have a massive head cold. If no one posts a "make all the ALTER IGNORE into ALTER only" patch later, I will. I'm going to bed. -- You are receiving this mail because: You are watching all bug changes.