From 7b29b4c18966eece6364abcf5724c6108141f049 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
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