From 7c260e550e28eafd0d7fe2ed774b67199c27192a Mon Sep 17 00:00:00 2001 From: Colin Campbell Date: Mon, 20 Jun 2011 15:48:57 +0100 Subject: [PATCH] Bug 5549 : replace curdate with now in a couple of sql lines duedate is now datetime and comparing with curdate causes a system error --- C4/Members.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/C4/Members.pm b/C4/Members.pm index 434a018cd6..1f0ac3f995 100644 --- a/C4/Members.pm +++ b/C4/Members.pm @@ -642,7 +642,7 @@ sub IsMemberBlocked { "SELECT COUNT(*) as latedocs FROM issues WHERE borrowernumber = ? - AND date_due < curdate()" + AND date_due < now()" ); $sth->execute($borrowernumber); my $latedocs = $sth->fetchrow_hashref->{'latedocs'}; @@ -680,7 +680,7 @@ sub GetMemberIssuesAndFines { $sth = $dbh->prepare( "SELECT COUNT(*) FROM issues WHERE borrowernumber = ? - AND date_due < curdate()" + AND date_due < now()" ); $sth->execute($borrowernumber); my $overdue_count = $sth->fetchrow_arrayref->[0]; -- 2.39.5