Re: [Koha] Patron search not working in 24.05 (Month out of range)

I was looking in Bugzilla to see if a bug report had already been created for this and found https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31143 It seems Wainui made a script for that, but it was mentioned it should be added to search_for_data_inconsistencies instead. On

Re: [Koha] Patron search not working in 24.05 (Month out of range)

Yep, We should add this to the script misc/maintenance/search_for_data_inconsistencies.pl Le 20/06/2024 à 13:39, philippe.blo...@inlibro.com a écrit : There are many fields we encountered this problem over the years.  As Caroline wrote last week: select

Re: [Koha] Patron search not working in 24.05 (Month out of range)

There are many fields we encountered this problem over the years. As Caroline wrote last week: select date_renewed,dateofbirth,dateenrolled,dateexpiry,lastseen,updated_on,debarred from borrowers where date_renewed = '-00-00' or dateexpiry = '-00-00' or dateenrolled = '-00-00' or

Re: [Koha] Patron search not working in 24.05 (Month out of range)

update borrowers set lastseen = NULL where lastseen = '-00-00 00:00:00'; fixed it for me. Am 20.06.24 um 09:59 schrieb zefanja: Hi, yesterday I did the upgrade to 24.05 (from 22.11 → 23.05 → 23.11 → 24.05) and I have the "500 - Month out of range" error again in patron search. I

[Koha] Patron search not working in 24.05 (Month out of range)

Hi, yesterday I did the upgrade to 24.05 (from 22.11 → 23.05 → 23.11 → 24.05) and I have the "500 - Month out of range" error again in patron search. I already checked the borrowers.date_renewed and set it to NULL, but the search is still not working