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 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/C4/Overdues.pm b/C4/Overdues.pm
index 707bd1b..f67f16a 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);
--
1.6.3.3
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
