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

Fridolin SOMERS <fridolin.som...@biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #52780|0                           |1
        is obsolete|                            |

--- Comment #18 from Fridolin SOMERS <fridolin.som...@biblibre.com> ---
Created attachment 56505
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=56505&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)
- Have a look at authoritie frameworks in Admin

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to