https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17952 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |18835 --- Comment #15 from Jonathan Druart <jonathan.druart@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.