Summary: | borrowers-force-messaging-defaults throws Incorrect DATE value: '0000-00-00' even though sql strict mode is dissabled | ||
---|---|---|---|
Product: | Koha | Reporter: | Stefan Norinder <somesecretemail> |
Component: | Command-line Utilities | Assignee: | Jonathan Druart <jonathan.druart> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | major | ||
Priority: | P5 - low | CC: | andrewfh, caroline.cyr-la-rose, fridolin.somers, jonathan.druart, robin, victor |
Version: | unspecified | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: |
21.05.00,20.11.01,20.05.07,19.11.14
|
|
Bug Depends on: | |||
Bug Blocks: | 17258, 7806 | ||
Attachments: |
Bug 27276: Prevent borrowers-force-messaging-defaults.pl to crash
Bug 27276: Prevent borrowers-force-messaging-defaults.pl to crash Bug 27276: Prevent borrowers-force-messaging-defaults.pl to crash Bug 27276:: Fix syntax error |
Description
Stefan Norinder
2020-12-18 06:53:32 UTC
It's a bug. Lowering severity a bit however. Created attachment 114520 [details] [review] Bug 27276: Prevent borrowers-force-messaging-defaults.pl to crash MySQL 5.7 does not allow queries using 0000-00-00 Stefan, can you try this patch? (I haven't tested it yet!) Created attachment 114768 [details] [review] Bug 27276: Prevent borrowers-force-messaging-defaults.pl to crash MySQL 5.7 does not allow queries using 0000-00-00 Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> Created attachment 114780 [details] [review] Bug 27276: Prevent borrowers-force-messaging-defaults.pl to crash MySQL 5.7 does not allow queries using 0000-00-00 Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz> Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Created attachment 114781 [details] [review] Bug 27276:: Fix syntax error Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> Pushed to master for 21.05, thanks to everybody involved! Pushed to 20.11.x for 20.11.01 Pushed to 20.05.x for 20.05.07 Backported: Pushed to 19.11.x branch for 19.11.14 |