https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23309
--- Comment #22 from Katrin Fischer <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
