| Summary: | sanitize_zero_date does not handle datetime | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Jonathan Druart <jonathan.druart> |
| Component: | Architecture, internals, and plumbing | Assignee: | Jonathan Druart <jonathan.druart> |
| Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
| Severity: | major | ||
| Priority: | P5 - low | CC: | andrew, fridolin.somers, victor |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Crowdfunding goal: | 0 |
| Patch complexity: | --- | Documentation contact: | |
| Documentation submission: | Text to go in the release notes: | ||
| Version(s) released in: |
21.05.00,20.11.04,20.05.10,19.11.16
|
Circulation function: | |
| Bug Depends on: | 26997 | ||
| Bug Blocks: | 7806 | ||
| Attachments: | Bug 27821: Make sanitize_zero_date support datetime and timestamp | ||
RMaints, keep an eye on this one, you may need to backport it quickly. Created attachment 117432 [details] [review] Bug 27821: Make sanitize_zero_date support datetime and timestamp Pushed to master for 21.05, thanks to everybody involved! Pushed to 20.11.x for 20.11.04 Pushed to 20.05.x for 20.05.10 Backported: Pushed to 19.11.x branch for 19.11.16 |
Only datatype "date" is handled correctly. Atomic update generated errors: main::sanitize_zero_date(): DBI Exception: DBD::mysql::db do failed: Truncated incorrect CHAR(10) value: '2021-03-01 09:43:56' [for Statement " UPDATE old_issues SET returndate = NULL WHERE CAST(returndate AS CHAR(10)) = '0000-00-00'; "] at (eval 1481) line 5