| Summary: | Unable to delete patron | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Nishath Ahmed <nishathahmed> |
| Component: | Patrons | Assignee: | 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: | ||
| Circulation function: | |||
| Attachments: | Koha-anon-info | ||
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. |
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