http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802
--- Comment #29 from Galen Charlton <[email protected]> --- Comment on attachment 22816 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=22816 Bug 7802: Remove CUR_DATE() and CURRENT_DATE() MySQLisms, replace by CAST(now() AS date). Review of attachment 22816: --> (http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=7802&attachment=22816) ----------------------------------------------------------------- ::: misc/cronjobs/longoverdue.pl @@ +130,5 @@ > SELECT items.itemnumber, borrowernumber, date_due > FROM issues, items > WHERE items.itemnumber = issues.itemnumber > + AND DATE_SUB(CAST(now() AS date), INTERVAL ? DAY) > date_due > + AND DATE_SUB(CAST(now() AS date), INTERVAL ? DAY) <= date_due DATE_SUB() is not portable to PostgreSQL. As implied by my previous comment, I'm much more interested in seeing patches that provably improve portability of the SQL, not ones that just search-and-replace. -- 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/
