[Koha-bugs] [Bug 27004] New: Deleting a staff account who have created claims returned causes problem in the return_claims table because of a NULL value in return_claims.created_by.

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27004

            Bug ID: 27004
           Summary: Deleting a staff account who have created claims
                    returned causes problem in the return_claims table
                    because of a NULL value in return_claims.created_by.
 Change sponsored?: ---
           Product: Koha
           Version: 19.11
          Hardware: All
                OS: All
            Status: NEW
          Severity: minor
          Priority: P5 - low
         Component: Patrons
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: enica at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

When a staff deletes another staff member's staff account and that particular
account happens to have created return_claims, it creates a NULL value in the
return_claims.created_by, causing a problem when another staff tries to resolve
the claims. On the patron's account Claim tab, when one tries to resolve the
claim, it will perpetually load without doing anything.

Only way to fix is update the NULL value on the created_by and add a
borrowernumber. Is there a way to transfer the claim to a different staff
account? Should Koha allow the deletion of an account when there are still
return_claims unresolved?

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.