Bug 27189

Summary: Unable to delete patron
Product: Koha Reporter: Nishath Ahmed <nishathahmed>
Component: PatronsAssignee: Bugs List <koha-bugs>
Status: RESOLVED MOVED QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: anke.bruns, gmcharlt, jonathan.druart, kyle.m.hall
Version: 20.11   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28267
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Koha-anon-info

Description Nishath Ahmed 2020-12-10 12:57:40 UTC
Created attachment 114306 [details]
Koha-anon-info

Hi There!

I couldn't delete patrons it says "Unable to delete patron that is set as AnonymousPatron
This patron cannot be deleted while set as AnonymousPatron in the system preferences."

I set an account with borrower-number (which is superlibrarian account and not meant for deletion) as well there on system preferences. Please check the attachment.  But still no luck. Please advice.

Regards!
Nishath
Comment 1 Jonathan Druart 2020-12-11 11:19:32 UTC
Can you confirm it's fixed by bug 27144?

*** This bug has been marked as a duplicate of bug 27144 ***
Comment 2 Anke Bruns 2021-12-29 14:33:32 UTC
I encounter the same in one of my Koha libraries. In other libraries (instances), even on the same server, the problem doesn't occur. What can be the reason?

To solve it, I tried several things which all didn't help:

- Created an AnonymousPatron user and set the AnonymousPatron parameter from default "0" to the new AnonymousPatron accordingly.

- deleted all entries from deletedborrowers which were duplicates to entries in borrowers. Interestingly, the borrowernumber of the borrower I had tried several times to delete showed up 6 times in deletedborrowers.

None of the patrons have a cardnumber starting with a leading 0 (as in Bug #11636). Yet no patron can be deleted.

Neither batch deletion nor deletion of a single borrower works. Deletion of a single borrower leads to the error message described here by Nishad Ahmed. Batch deletion leads to Internal server error.
Comment 3 Katrin Fischer 2022-01-02 15:10:37 UTC
We finally tracked this down to a DBD::mysql::db do failed: Row size too large.  error on the borrower_modifications table. The failed update would have added the extended_attributes column which than caused the issue on patron deletion.

I am reclosing this, but with a link to bug 28267.