Bug 26688

Summary: Problem importing ILL-requests
Product: Koha Reporter: Jonas <jonas.rogander>
Component: ILLAssignee: Bugs List <koha-bugs>
Status: RESOLVED MOVED QA Contact:
Severity: enhancement    
Priority: P5 - low CC: magnus
Version: unspecified   
Hardware: PC   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Jonas 2020-10-15 09:27:21 UTC 
We've started to get a problem recently when trying to import ILL-requests with a third party module. It has worked like a charm for over a year but recently it crashes on some items with this error message:

Use of uninitialized value in join or string at /usr/share/perl5/MARC/Field.pm line 696.
Use of uninitialized value in join or string at /usr/share/perl5/MARC/Field.pm line 696.
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_koha`.`biblio_metadata`, CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "INSERT INTO `biblio_metadata` ( `format`, `marcflavour`, `metadata`) VALUES ( ?, ?, ? )"
Broken FK constraint

Some items will get imported but then on some items this error message occurs and the script crashes.

Koha version 18.11.16.000.
Comment 1 Katrin Fischer 2020-10-15 09:28:29 UTC 
How are you importing the ILL requests?
Comment 2 Jonas 2020-10-15 09:33:29 UTC 
(In reply to Katrin Fischer from comment #1)
> How are you importing the ILL requests?

Im using this module https://github.com/Libriotech/koha-illbackend-libris
Not the most recent one tho since its for Koha 20.05
Comment 3 Katrin Fischer 2020-10-15 09:38:11 UTC 
Hi Jonas, the ILL backends are not supported by community but act more like plugins that are maintained by their developers. I recommend to file an issue on the issue tracker on github for your problem (I see now you already did).

You are also on a rather old Koha version, so maybe plugin code and your Koha version are conflicting?
Comment 4 Magnus Enger 2020-10-15 11:23:13 UTC 
We'll try and fix this over on Github. :-)