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: koha-bugs@lists.koha-community.org Reporter: lisette@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org 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.