From 7b29b4c18966eece6364abcf5724c6108141f049 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 21 Jun 2017 10:59:57 -0300 Subject: [PATCH] Bug 18835: Fix SQL syntax error in overdue_notices.pl Caused by bug 17952, an extra / is in the middle of the query. --- misc/cronjobs/overdue_notices.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/misc/cronjobs/overdue_notices.pl b/misc/cronjobs/overdue_notices.pl index cb95ee5..7497381 100755 --- a/misc/cronjobs/overdue_notices.pl +++ b/misc/cronjobs/overdue_notices.pl @@ -468,7 +468,7 @@ SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, branchname AND issues.borrowernumber = ? AND issues.branchcode = ? AND items.itemlost = 0 -/ AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 + AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0 END_SQL my $query = "SELECT * FROM overduerules WHERE delay1 IS NOT NULL AND branchcode = ? "; -- 2.1.4