[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