[Koha-bugs] [Bug 23309] Can't add new subfields to bibliographic frameworks in strict mode

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

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

--- Comment #22 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Corinne Hayet from comment #21)
> Sorry but it still does not work. 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

Hi Corinne, thx for being persistent! As this is already in stable, would you
mind filing a new bug and linking to this one? (Depends on). We will have to
treat it as a new bug and take a look into fixing it.

-- 
You are receiving this mail because:
You are watching all bug changes.