Patron searches give 500 error

Problem statement: The following error message when searching for patron names.

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.

Reason: The date_renewed column has some proper dates, some NULLs and some 0000-00-00.

Solution: Uupdate borrowers set date_renewed = NULL where date_renewed = '0000-00-00'. Enter into the MariaDB and apply the following commands,

sudo mysql -uroot -p

use koha_library;

UPDATE borrowers

SET date_renewed = NULL;

Idea courtesy: Mahesh Palamuttath

Reference

https://irc.koha-community.org/koha/2023-04-26#i_2483964