Reported:
2022-07-12 16:05 UTC by Martin Renvoize (ashimema)
Modified:
2024-12-27 08:58 UTC
(History )
CC List:
17
users
(show )
adifbbk1
aleisha
caroline.cyr-la-rose
danyonsewell
david
dcook
fridolin.somers
jonathan.druart
Laura.escamilla
lucas
nick
paul.derscheid
pedro.amorim
philippe.blouin
r.delahunty
shi-yao.wang
wainuiwitikapark
See Also:
Patch complexity:
---
Documentation contact:
Documentation submission:
Text to go in the release notes:
This enhancement:
1. Updates the misc/maintenance/search_for_data_inconsistencies.pl script so that it identifies any date fields that have 0000-00-00 values.
2. Adds a new script misc/maintenance/fix_invalid_dates.pl that fixes any date fields that have '0000-00-00' values (for example: dateofbirth) by updating them to 'NULL'.
Patron, item, and other date fields with a value of '000-00-00' can cause errors. This includes:
- API errors
- stopping the patron autocomplete search working
- generating a 500 internal server error:
. for normal patron searching
. when displaying item data in the holdings table
Version(s) released in:
24.11.00,24.05.06,23.11.11
Circulation function: