[Koha-bugs] [Bug 33362] New: Return claims can be un-resolvable if issue_id is set but no issue is found in issues or old_issues

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: kyle at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at 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.