[Bug 27189] New: Unable to delete patron
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27189 Bug ID: 27189 Summary: Unable to delete patron Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: nishathahmed@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Created attachment 114306 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114306&action=edit 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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27189 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |jonathan.druart@bugs.koha-c | |ommunity.org Resolution|--- |DUPLICATE --- Comment #1 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- Can you confirm it's fixed by bug 27144? *** This bug has been marked as a duplicate of bug 27144 *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27189 Anke <anke.bruns@gwdg.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|DUPLICATE |--- Status|RESOLVED |REOPENED CC| |anke.bruns@gwdg.de --- Comment #2 from Anke <anke.bruns@gwdg.de> --- 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. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27189 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |MOVED --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27189 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=28267 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org