Attachment 64488 Details for Bug 18835 – Bug 18835: Fix SQL syntax error in overdue_notices.pl

[patch] Bug 18835: Fix SQL syntax error in overdue_notices.pl

Bug-18835-Fix-SQL-syntax-error-in-overduenoticespl.patch (text/plain), 993 bytes, created by Jonathan Druart on 2017-06-21 14:01:52 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2017-06-21 14:01:52 UTC

Size: 993 bytes

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 18835: 64488