Bug 26688 - Problem importing ILL-requests
Summary: Problem importing ILL-requests
Status: RESOLVED MOVED
Alias: None
Product: Koha
Classification: Unclassified
Component: ILL (show other bugs)
Version: unspecified
Hardware: PC Linux
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-10-15 09:27 UTC by Jonas
Modified: 2020-10-15 11:23 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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. :-)