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

[Fridolin SOMERS]

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

-- 
Fridolin SOMERS <fridolin.somers at biblibre.com>
Software and system maintainer 🦄
BibLibre, France