[Koha-bugs] [Bug 7802] A MySQLism is used to get the current date.

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Sun Apr 28 20:04:46 CEST 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802

--- Comment #33 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---

Still an issue:

C4/Acquisition.pm:                DATEDIFF(CURDATE( ),closedate) AS latesince
C4/Acquisition.pm:            claimed_date = CURDATE()
C4/NewsChannels.pm:     AND   DATE(timestamp) < DATE_ADD(CURDATE(), INTERVAL 1
DAY)
circ/overdue.pl:        $strsth .= " AND borrowers.debarred >=  CURDATE()" ;
misc/cronjobs/longoverdue.pl:our $bounds_sth =
C4::Context->dbh->prepare("SELECT DATE_SUB(CURDATE(), INTERVAL ? DAY)");
misc/cronjobs/longoverdue.pl:      AND  DATE_SUB(CURDATE(), INTERVAL ? DAY)  >
date_due
misc/cronjobs/longoverdue.pl:      AND  DATE_SUB(CURDATE(), INTERVAL ? DAY) <=
date_due
misc/cronjobs/remove_temporary_edifiles.pl:and datediff( CURDATE(),
transfer_date ) > 5

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list