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)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 23 Feb 2021 12:07:49 +0000 (13:07 +0100)
commit0e0700a691621b2ef1de46fa0ea18ee771daadaf
tree33f6d0b167d845084a729119909781715253ab65
parent3c087bc216eeab8fe0d68a2d33407b554bc57074
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>
acqui/ordered.pl
acqui/spent.pl