[Koha-bugs] [Bug 23709] New: Can't add new subfields to bibliographic frameworks
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Oct 1 09:21:55 CEST 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709
Bug ID: 23709
Summary: Can't add new subfields to bibliographic frameworks
Change sponsored?: ---
Product: Koha
Version: 18.11
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: P5 - low
Component: Cataloging
Assignee: koha-bugs at lists.koha-community.org
Reporter: corinne.hayet at progilone.fr
QA Contact: testopia at bugs.koha-community.org
CC: m.de.rooy at rijksmuseum.nl
It only works if the subfield is connected to an Authorized values list.
I created a subfield 099$m with a link with COUNTRY authorized values list and
it's OK
But, if I try to create a simple subfield 012$z and I've got the following
error in logs :
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha`.`marc_subfield_structure`,
CONSTRAINT `marc_subfield_structure_ibfk_1` FOREIGN KEY
(`authorised_value`) REFERENCES `authorised_value_categories`
(`category_name`) ON DELETE SET NULL ON ) [for Statement "INSERT INTO
`marc_subfield_structure` ( `authorised_value`, `authtypecode`, `defaultvalue`,
`frameworkcode`, `hidden`, `isurl`, `kohafield`, `liblibrarian`, `libopac`,
`link`, `mandatory`, `maxlength`, `repeatable`, `seealso`, `tab`, `tagfield`,
`tagsubfield`,
`value_builder`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
)" with ParamValues: 0="", 1="", 2="", 3="", 4="0", 5=0, 6="", 7="test",
8="test", 9="", 10=0, 11="9999", 12=0, 13=undef, 14="0", 15="013", 16="x",
17=""] at /usr/local/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
Best regards,
Corinne
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list