Connexion
Patron searches give 500 error
18 novembre 2023 à 03:45
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.
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
