[Koha-bugs] [Bug 17952] Lost items not skipped by overdue_notices.pl

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17952

Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |18835

--- Comment #15 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Benjamin Rokseth from comment #14)
> seems a slash snuck into the patch?
> 
> @@ -466,7 +467,8 @@ SELECT biblio.*, items.*, issues.*,
> biblioitems.itemtype, branchname
>      AND biblio.biblionumber   = biblioitems.biblionumber
>      AND issues.borrowernumber = ?
>      AND issues.branchcode = ?
> -    AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
> +    AND items.itemlost = 0
> +/   AND TO_DAYS($date)-TO_DAYS(issues.date_due) >= 0
>  END_SQL
> 
> this breaks the query

This is terrible, I should have caught that.
See bug 18835.


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18835
[Bug 18835] SQL syntax error in overdue_notices.pl
-- 
You are receiving this mail because:
You are watching all bug changes.