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
Can you confirm it's fixed by bug 27144? *** This bug has been marked as a duplicate of bug 27144 ***
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.
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.