https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40697
Bug ID: 40697
Summary: Failures on batch record import because of
fkconstraint should report in job report
Change sponsored?: ---
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Created attachment 185722
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=185722&action=edit
Current display in staff interface
If a import fails because of an FK_Constraint issue, there is no helpful
information in the interface.
It would be very helpful for users if it show that, for example, the branch
wasn't valid.
I've attached a screenshot of what it looks like in the interface.
Example in worker-output.log:
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Cannot add or update a child row: a foreign key constraint
fails (`koha_kohadev`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN KEY
(`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/usr/share/koha/lib/Koha/Object.pm line 172
Broken FK constraint at
/usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 90.
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Cannot add or update a child row: a foreign key constraint
fails (`koha_kohadev`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN KEY
(`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/usr/share/koha/lib/Koha/Object.pm line 172
Broken FK constraint at
/usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 90.
DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
execute failed: Cannot add or update a child row: a foreign key constraint
fails (`koha_kohadev`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN KEY
(`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at
/usr/share/koha/lib/Koha/Object.pm line 172
Broken FK constraint at
/usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 90.
--
You are receiving this mail because:
You are the assignee for the bug.
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/
