[Bug 38150] New: Patron search error
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38150 Bug ID: 38150 Summary: Patron search error Change sponsored?: --- Product: Koha Version: 23.11 Hardware: PC OS: Linux Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: librarian@sageuniversity.in QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com Dear Sir/madam Please help to resolve this issue : I have a system with Ubuntu 22.04 and Koha version 23.11.08 Yesterday I installed koha 23.11.08 in Ubuntu 22.04. When I search any patron by name I am getting this error Something went wrong when loading the table. 500: Internal Server Error. Month out of range. -- 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=38150 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|NEW |RESOLVED --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hi, this is due to an invalid date in your borrowers table (0000-00-00). Bug 31143 works on a script to identify and fix these errors. Meanwhile you can find the problematic ones with SQL: select date_renewed, dateofbirth, dateenrolled, dateexpiry, lastseen, updated_on, debarred from borrowers where date_renewed = '0000-00-00' or dateexpiry = '0000-00-00' or dateenrolled = '0000-00-00' or dateofbirth = '0000-00-00' or lastseen = '0000-00-00' or updated_on = '0000-00-00' or debarred = '0000-00-00'; You need to replace them with NULL. -- 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