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.blo...@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-r...@inlibro.com
https://www.inLibro.com
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
