Back to bug 31143

Who When What Removed Added
katrin.fischer 2023-06-17 13:12:36 UTC Depends on 18016, 28440
dcook 2023-06-19 02:06:34 UTC CC dcook
wainuiwitikapark 2023-08-07 00:38:52 UTC Status NEW ASSIGNED
CC wainuiwitikapark
Assignee koha-bugs wainuiwitikapark
wainuiwitikapark 2023-08-07 04:41:38 UTC Status ASSIGNED Needs Signoff
Laura.escamilla 2023-08-07 15:12:03 UTC Status Needs Signoff Failed QA
CC Laura.escamilla
wainuiwitikapark 2023-08-13 22:31:08 UTC Attachment #154299 Attachment is obsolete 0 1
wainuiwitikapark 2023-08-13 22:31:46 UTC Status Failed QA Needs Signoff
david 2023-09-20 23:48:57 UTC Status Needs Signoff Signed Off
david 2023-09-20 23:49:00 UTC Attachment #154399 Attachment is obsolete 0 1
david 2023-09-21 00:16:45 UTC CC david
Text to go in the release notes , and generate a 500 internal server error issue with normal patron searching. This new script identifies patron fields that have '0000-00-00' for date fields (for example: dateofbirth) and updates them to 'NULL'. Date fields with a value of '000-00-00' can cause upgrade and API issues, stop the autocomplete patron search working
jonathan.druart 2023-09-29 14:26:52 UTC CC jonathan.druart+koha
Status Signed Off Failed QA
lucas 2023-10-12 17:02:48 UTC CC lucas
caroline.cyr-la-rose 2024-06-25 13:49:34 UTC CC caroline.cyr-la-rose, philippe.blouin
fridolin.somers 2024-06-25 18:59:54 UTC CC fridolin.somers
wainuiwitikapark 2024-07-03 04:12:25 UTC Assignee wainuiwitikapark koha-bugs
wainuiwitikapark 2024-07-09 05:52:32 UTC Assignee koha-bugs wainuiwitikapark
wainuiwitikapark 2024-07-09 06:15:35 UTC Status Failed QA ASSIGNED
wainuiwitikapark 2024-07-09 07:05:38 UTC Attachment #155964 Attachment is obsolete 0 1
wainuiwitikapark 2024-07-09 07:06:09 UTC Status ASSIGNED Needs Signoff
jonathan.druart 2024-07-09 13:25:48 UTC Status Needs Signoff Failed QA
jonathan.druart 2024-07-09 13:27:09 UTC Comment 17 Tag obsolete
wainuiwitikapark 2024-07-09 23:15:00 UTC Assignee wainuiwitikapark koha-bugs
wainuiwitikapark 2024-07-10 23:35:40 UTC Assignee koha-bugs wainuiwitikapark
wainuiwitikapark 2024-07-11 01:48:36 UTC Attachment #168636 Attachment is obsolete 0 1
wainuiwitikapark 2024-07-11 01:49:15 UTC Status Failed QA Needs Signoff
wainuiwitikapark 2024-07-11 07:53:43 UTC Attachment #168770 Attachment is obsolete 0 1
wainuiwitikapark 2024-07-11 07:57:36 UTC Attachment #168775 Attachment is obsolete 0 1
david 2024-07-15 03:23:48 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36027
wainuiwitikapark 2024-08-01 21:48:57 UTC Priority P5 - low P2
paul.derscheid 2024-08-06 09:23:22 UTC CC paul.derscheid
pedro.amorim 2024-08-06 09:45:43 UTC CC pedro.amorim
wainuiwitikapark 2024-08-13 05:11:35 UTC Assignee wainuiwitikapark koha-bugs
Priority P2 P1 - high
r.delahunty 2024-08-15 13:39:48 UTC CC r.delahunty
danyonsewell 2024-08-23 02:40:01 UTC CC danyonsewell
david 2024-08-26 05:08:51 UTC Status Needs Signoff Signed Off
david 2024-08-26 05:08:54 UTC Attachment #168776 Attachment is obsolete 0 1
david 2024-08-26 05:08:57 UTC Attachment #170086 Attachment is obsolete 0 1
david 2024-08-26 05:21:49 UTC Text to go in the release notes This new script identifies patron fields that have '0000-00-00' for date fields (for example: dateofbirth) and updates them to 'NULL'. Date fields with a value of '000-00-00' can cause upgrade and API issues, stop the autocomplete patron search working, and generate a 500 internal server error issue with normal patron searching. , and generate a 500 internal server error issue with normal patron searching. This enhancement:

1. Updates the misc/maintenance/search_for_data_inconsistencies.pl script so that it identifies patrons with any date fields that have 0000-00-00 values.

2. Adds a new script misc/cronjobs/fix_invalid_dates.pl that fixes any patron date fields that have '0000-00-00' values (for example: dateofbirth) by updating them to 'NULL'. Patron date fields with a value of '000-00-00' can cause upgrade and API issues, stop the autocomplete patron search working
david 2024-08-26 05:33:43 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37725
david 2024-08-26 05:34:21 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31093
katrin.fischer 2024-09-02 07:48:58 UTC Assignee koha-bugs wainuiwitikapark
wainuiwitikapark 2024-09-20 00:36:20 UTC Attachment #170697 Attachment is obsolete 0 1
wainuiwitikapark 2024-09-20 00:36:41 UTC Status Signed Off ASSIGNED
wainuiwitikapark 2024-09-20 00:38:42 UTC Attachment #171812 Attachment is obsolete 0 1
wainuiwitikapark 2024-09-20 00:41:42 UTC Attachment #171813 Attachment is obsolete 0 1
wainuiwitikapark 2024-09-20 00:48:09 UTC Attachment #171814 Attachment is obsolete 0 1
wainuiwitikapark 2024-09-20 01:02:53 UTC Attachment #171816 Attachment is obsolete 0 1
wainuiwitikapark 2024-09-20 01:32:46 UTC Status ASSIGNED Needs Signoff
wainuiwitikapark 2024-09-24 05:55:31 UTC Attachment #171815 Attachment is obsolete 0 1
wainuiwitikapark 2024-09-24 05:55:57 UTC Attachment #171817 Attachment is obsolete 0 1
shi-yao.wang 2024-09-26 14:24:12 UTC Attachment #170698 Attachment is obsolete 0 1
shi-yao.wang 2024-09-26 14:24:15 UTC Attachment #171918 Attachment is obsolete 0 1
shi-yao.wang 2024-09-26 14:24:38 UTC Status Needs Signoff Signed Off
CC shi-yao.wang
wainuiwitikapark 2024-09-26 22:28:36 UTC Text to go in the release notes This enhancement:

1. Updates the misc/maintenance/search_for_data_inconsistencies.pl script so that it identifies patrons with any date fields that have 0000-00-00 values.

2. Adds a new script misc/cronjobs/fix_invalid_dates.pl that fixes any patron date fields that have '0000-00-00' values (for example: dateofbirth) by updating them to 'NULL'. Patron date fields with a value of '000-00-00' can cause upgrade and API issues, stop the autocomplete patron search working, and generate a 500 internal server error issue with normal patron searching.
This enhancement:

1. Updates the misc/maintenance/search_for_data_inconsistencies.pl script so that it identifies any occurrences in the database with any date fields that have 0000-00-00 values.

2. Adds a new script misc/cronjobs/fix_invalid_dates.pl that fixes any date fields that have '0000-00-00' values by updating them to 'NULL'.
nick 2024-09-27 17:45:54 UTC Status Signed Off Passed QA
nick 2024-09-27 17:45:57 UTC Attachment #171976 Attachment is obsolete 0 1
nick 2024-09-27 17:46:01 UTC Attachment #171977 Attachment is obsolete 0 1
nick 2024-09-27 17:47:53 UTC CC nick
nick 2024-09-27 17:56:08 UTC Attachment #172138 Attachment is obsolete 0 1
nick 2024-09-27 17:56:11 UTC Attachment #172139 Attachment is obsolete 0 1
nick 2024-09-27 17:56:14 UTC Attachment #172140 Attachment is obsolete 0 1
nick 2024-09-27 17:56:17 UTC Attachment #172141 Attachment is obsolete 0 1
david 2024-09-27 21:05:04 UTC 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 occurrences in the database with any date fields that have 0000-00-00 values.

2. Adds a new script misc/cronjobs/fix_invalid_dates.pl that fixes any date fields that have '0000-00-00' values by updating them to 'NULL'.
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
martin.renvoize 2024-09-30 14:40:13 UTC QA Contact testopia nick
katrin.fischer 2024-10-23 17:41:39 UTC Keywords additional_work_needed
katrin.fischer 2024-10-23 18:03:06 UTC Status Passed QA Pushed to main
Version(s) released in 24.11.00
katrin.fischer 2024-10-24 09:14:33 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38254
martin.renvoize 2024-10-28 09:34:15 UTC See Also https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36822
aleisha 2024-11-13 22:11:04 UTC Keywords rel_24_05_candidate
CC aleisha
katrin.fischer 2024-11-14 15:38:49 UTC Keywords additional_work_needed
lucas 2024-11-15 16:03:43 UTC Keywords rel_24_05_candidate
Version(s) released in 24.11.00 24.11.00,24.05.06
Status Pushed to main Pushed to stable
fridolin.somers 2024-12-02 08:34:54 UTC Version(s) released in 24.11.00,24.05.06 24.11.00,24.05.06,23.11.11
Status Pushed to stable Pushed to oldstable
adifbbk1 2024-12-23 09:59:24 UTC CC adifbbk1
katrin.fischer 2024-12-27 08:58:27 UTC Blocks 38788

Back to bug 31143