]> git.koha-community.org Git - koha.git/commit
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)
committerVictor Grousset/tuxayo <victor@tuxayo.net>
Thu, 18 Mar 2021 20:02:44 +0000 (21:02 +0100)
commitbc5910ee5e53421cfbf40ec980ebe8953e3fc5ab
treee3bc2ba79908d7ec7f4d123e3c67a8d18136266c
parent7e3bf82654d85e9bed1ff45a201dd2b9e54c2e4f
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>
(cherry picked from commit 9a5927c322e2949f8b86461499bcc247a6572154)
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
acqui/ordered.pl
acqui/spent.pl