[Koha-bugs] [Bug 17952] Lost items not skipped by overdue_notices.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Jun 21 10:13:11 CEST 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17952
Benjamin Rokseth <benjamin.rokseth at kul.oslo.kommune.no> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |benjamin.rokseth at kul.oslo.k
| |ommune.no
--- Comment #14 from Benjamin Rokseth <benjamin.rokseth at kul.oslo.kommune.no> ---
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
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list