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

[Caroline Cyr La Rose]

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 2024-06-24 11:37, Fridolin SOMERS wrote:
> Yep,
>
> We should add this to the script 
> misc/maintenance/search_for_data_inconsistencies.pl
>
> Le 20/06/2024 à 13:39, philippe.blouin at inlibro.com a écrit :
>> 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 = '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';
>>
>>
>> On 2024-06-20 06:18, zefanja wrote:
>>> update borrowers set lastseen = NULL where lastseen = '0000-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 already checked the borrowers.date_renewed  and set it to NULL, 
>>>> but the search is still not working 
>>>> (https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32641)
>>>>
>>>> I have no errors in intranet-errors.log
>>>>
>>>> Any ideas how to solve or at least debug the issue?
>>>>
>>>> Thank you!
>>>> Stephan
>>>> _______________________________________________
>>>>
>>>> Koha mailing list  http://koha-community.org
>>>> Koha at lists.katipo.co.nz
>>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>>> _______________________________________________
>>>
>>> Koha mailing list  http://koha-community.org
>>> Koha at lists.katipo.co.nz
>>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>> _______________________________________________
>>
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
Caroline Cyr-La-Rose, M.L.I.S. (she/her)
Librarian | Product Manager

1-833-INLIBRO (465-4276), ext. 221
caroline.cyr-la-rose at inlibro.com
https://www.inLibro.com