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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

---

Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

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@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@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

---

Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

---

Koha mailing list  http://koha-community.org Koha@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@inlibro.com https://www.inLibro.com