https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17952
Jonathan Druart <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |18835 --- Comment #15 from Jonathan Druart <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
