From cb170fe4ff807a9299adfb56acf84e66996f20f1 Mon Sep 17 00:00:00 2001 From: Colin Campbell Date: Fri, 17 Jun 2011 12:13:47 +0100 Subject: [PATCH 1/1] Bug 5549 : Cannot use CUR_DATE on date_due column Comparison of CUR_TIME() & datetime gives table corrupted error in mysql Plus we want to see hourly loans --- C4/Overdues.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Overdues.pm b/C4/Overdues.pm index 660e10b830..afccdb5cd5 100644 --- a/C4/Overdues.pm +++ b/C4/Overdues.pm @@ -1218,7 +1218,7 @@ sub GetOverduesForBranch { WHERE (accountlines.amountoutstanding != '0.000000') AND (accountlines.accounttype = 'FU' ) AND (issues.branchcode = ? ) - AND (issues.date_due < CURDATE()) + AND (issues.date_due < NOW()) "; my @getoverdues; my $i = 0; -- 2.20.1