[Koha] While searching patron getting the error (koha upgraded from 19.05 to

[Katrin Fischer]

Hi,

we recently saw a similar issue. It turned out that we had invalid dates
in borrowers.date_renewed. To verify you could create a report:

select * from borrowers where date_renewed = '0000-00-00';

If that returns results, you have the same problem we had. I think these
can only be fixed from server side with an update statement:

update borrowers set date_renewed = NULL where date_renewed = '0000-00-00';

Hope this helps,

Katrin


On 06.02.24 11:43, Shankar Reddy Kolle wrote:
> Dear Sir/madam
>
> Please help to resolve this issue :
>
> I have a system with Ubuntu 16.04 and Koha version 19.05.
> Yesterday I installed koha 22.05.08 in Ubuntu 22.04.
> and migrated the old data (Koha 19.05)  to (Koha 22.05.08.
> When I search any patron by name I am getting this error
>
> Something went wrong when loading the table.
> 500: Internal Server Error.
> Month out of range.
> Month out of range.
> Month out of range.
> Month out of range.
> Month out of range.
> Month out of range.
> Month out of range.
>
> Hoping for the solution
>
> Thank you