From e36297e861e4a45ec6fdbc7c9205a9b4db75ffbe 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. Signed-off-by: Jonathan Druart (cherry picked from commit 939eadc5d987429db04887623c3f260ee02b86d2) Signed-off-by: Fridolin Somers --- 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 cb95ee52e4..74973816c5 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.39.5