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