Bug 27189 - Unable to delete patron
Summary: Unable to delete patron
Status: RESOLVED MOVED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 20.11
Hardware: All All
: P5 - low major (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-10 12:57 UTC by Nishath Ahmed
Modified: 2022-01-02 15:13 UTC (History)
4 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Koha-anon-info (95.00 KB, image/png)
2020-12-10 12:57 UTC, Nishath Ahmed
Details

Note You need to log in before you can comment on or make changes to this bug.
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.