From 0c1d86c939fc89033cd2a13b8c03fe6cdc284a4d Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Thu, 14 Jan 2010 10:01:22 +0100 Subject: [PATCH] (bug #4043) fix checkoverdues sqlquery this fix the sqlquery to use "curdate()" instead of "now()", because now return a "datetime", and in date_due we have only a "date", so now() > curdate() everytime, it cause some problems in messages. --- C4/Overdues.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Overdues.pm b/C4/Overdues.pm index 707bd1b832..f67f16a4a3 100644 --- a/C4/Overdues.pm +++ b/C4/Overdues.pm @@ -169,7 +169,7 @@ sub checkoverdues { LEFT JOIN biblio ON items.biblionumber = biblio.biblionumber LEFT JOIN biblioitems ON items.biblioitemnumber = biblioitems.biblioitemnumber WHERE issues.borrowernumber = ? - AND issues.date_due < NOW()" + AND issues.date_due < CURDATE()" ); # FIXME: SELECT * across 4 tables? do we really need the marc AND marcxml blobs?? $sth->execute($borrowernumber); -- 2.39.5