[Koha-bugs] [Bug 16554] Web installer fails to load i18n sample data on MySQL 5.6+

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16554

--- Comment #54 from M. Tompsett <mtompset at 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.