http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15666 Bug ID: 15666 Summary: Automatic_renewals.pl fails when OverduesBlockRenewing and RestrictionBlockRenewing are set to "block" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs@lists.koha-community.org Reporter: costalc@gmail.com QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com 1) Now, when automatic_renewals.pl tries to renew due items the sysprefs vars OverduesBlockRenewing and RestrictionBlockRenewing don't allow renewing. That's right for these sysprefs vars but not for renewing. 2) Automatic_renewals.pl should work like a user should: must renew his issues the date they due. 3) Thus automatic_renewals.pl should always avoid loans expire. So automatic_renewals.pl must consider only issues which due date is equal to the date automatic_renewals.pl is executing. 4) I think that CanBookBeRenewed in Circulation.pm must be updated but do not how... 5) In automatic_renewals.pl it is needed to change the mysql command to this one: SELECT borrowernumber, itemnumber, branchcode FROM issues WHERE auto_renew = 1 AND DATE(date_due) = DATE(NOW()) ------------------ I will attach a sample soon... -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.