https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16797 Fridolin SOMERS <fridolin.somers@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #52680|0 |1 is obsolete| | --- Comment #4 from Fridolin SOMERS <fridolin.somers@biblibre.com> --- Created attachment 52780 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=52780&action=edit Bug 16797 - errors in UNIMARC complet sample authorities The SQL UNIMARC complet sample authorities fails : installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql Some lines of auth_subfield_structure use an authtypecode not existing in lines of authtypecode : AUTTIT, SAUT, SCO and STU. Test plan : - On a UNIMARC database : - clear auth tables : mysql> delete from auth_subfield_structure; mysql> delete from auth_tag_structure; mysql> delete from auth_types; - import sql file : mysql < installer/data/mysql/fr-FR/marcflavour/unimarc_complet/Obligatoire/autorites_norme_unimarc.sql => Without patch you get error : ERROR 1452 (23000) at line 1132: Cannot add or update a child row: a foreign key constraint fails (`koha`.`auth_subfield_structure`, CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE) => With patch no errors :
select distinct(authtypecode) from auth_subfield_structure; +--------------+ | authtypecode | +--------------+ | | | CO | | CO_UNI_TI | | FAM | | GENRE/FORM | | NAME_COL | | NP | | PA | | SAUTTIT | | SNC | | SNG | | TM | | TU | +--------------+ 13 rows in set (0.00 sec)
-- You are receiving this mail because: You are watching all bug changes.