https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42303
Bug ID: 42303
Summary: Duplicate itemnumber in items and deleteditems table
when order cancel fails
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P5 - low
Component: Acquisitions
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Noticed this while working on bug 41169. It's possible to end up with duplicate
itemnumber in items and deleteditems table when cancelling an order. I
attempted to cancel an order and one of the items is present in
items_last_borrower table. This caused Koha to die on error 500 and exception
[Foreign key constraint broken on deleting resource] was raised. After some
debugging I tried canceling again and got:
>DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st
>execute failed: Duplicate entry '227661' for key 'PRIMARY'
since item is now in both items and deleteditems table after failed cancel.
--
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/
