https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33362 Bug ID: 33362 Summary: Return claims can be un-resolvable if issue_id is set but no issue is found in issues or old_issues Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: kyle@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com The column return_claims.issue_id is not a foreign key. If for any reason the issue is removed ( such as via cleanup_database.pl ), that claim will raise an FKConstraint exception every time an attempt is made to resolve it. We should either split that column into two with foreign key constrains, or allow the claim to be resolved even if the related issues cannot be found. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.