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)
committerAndrew Fuerste-Henry <andrew@bywatersolutions.com>
Thu, 4 Mar 2021 18:00:34 +0000 (18:00 +0000)
commit9a5927c322e2949f8b86461499bcc247a6572154
treecb0a12302e6d489cb11ff58dc79bfa100c742200
parentc720acc3c915b5c493edd66a65e5519a40e5486b
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>
(cherry picked from commit e6aeb00c1059736c535a45d1a551eaa22c20b01f)

Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
acqui/ordered.pl
acqui/spent.pl