Bug 26997: Remove 0000-00-00 from aqorders.datecancellationprinted
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 13 Nov 2020 12:59:46 +0000 (13:59 +0100)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 25 Feb 2021 09:23:37 +0000 (10:23 +0100)
commite6aeb00c1059736c535a45d1a551eaa22c20b01f
treef7011102cfe9f396646cadf1dd7e6b3fe74ec4a9
parentda58f3e2c541bb617ba3ec5ef58d5cf1792caeb7
Bug 26997: Remove 0000-00-00 from aqorders.datecancellationprinted

This patch remove the 0000-00-00 from the WHERE condition from
ordered.pl and spent.pl to prevent an error under MySQL 8

It also fixes the wrong values in DB (if possible, ie. under other DBMS
that MySQL 8)

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
(cherry picked from commit 0e0700a691621b2ef1de46fa0ea18ee771daadaf)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
acqui/ordered.pl
acqui/spent.pl