[Bug 23709] New: Can't add new subfields to bibliographic frameworks
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@lists.koha-community.org Reporter: corinne.hayet@progilone.fr QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@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.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 Corinne Hayet <corinne.hayet@progilone.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |23309 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23309 [Bug 23309] Can't add new subfields to bibliographic frameworks in strict mode -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |17258 CC| |katrin.fischer@bsz-bw.de Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17258 [Bug 17258] [OMNIBUS] MySQL 5.7 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Corinne, can you confirm you still get this error using the last 18.11.x version? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 --- Comment #2 from Corinne Hayet <corinne.hayet@progilone.fr> --- yep, we use 18.11.10 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 --- Comment #3 from Corinne Hayet <corinne.hayet@progilone.fr> --- both if you add a subfield using "edit/add subfield" menu or using import framework function -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 --- Comment #4 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- My guess is that the instance does not have the empty string value in authorised_value_categories. Could you: SELECT COUNT(*) FROM authorised_value_categories WHERE category_name=""; If if returns 0 you can insert it using: INSERT INTO authorised_value_categories(category_name) VALUES (""); Is it an old instance? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|critical |normal --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Lowering severity until it is confirmed. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #6 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- No answer, closing. Please reopen if still valid. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 --- Comment #7 from Corinne Hayet <corinne.hayet@progilone.fr> --- Sorry for being late. For me, it still doesn't work in 18.11.11 despite we applied the patch. First installation was made with standard koha source (no migration) SQL query : SELECT COUNT(*) FROM authorised_value_categories WHERE category_name=""; give 1 as result. After applying the patch, we can add a subfield but we cannot update framework using import function. Corinne -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23709 --- Comment #8 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Corinne Hayet from comment #7)
After applying the patch, we can add a subfield but we cannot update framework using import function.
Bonjour Corinne, So it sounds like something else. Can you detail the steps behind "using import function"? See also bug 23398, which may be related ("Export to XML" is broken basically). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org