https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10190 --- Comment #808 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 204498 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=204498&action=edit DB for testing zcat bug_10190_test_db.sql.gz | sudo koha-mysql kohadev sudo koha-mysql kohadev UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 8 DAY) WHERE barcode="AAAT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 9 DAY) WHERE barcode="AAAT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 10 DAY) WHERE barcode="AAAT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 7 DAY) WHERE barcode="AABT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 8 DAY) WHERE barcode="AABT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 9 DAY) WHERE barcode="AABT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 6 DAY) WHERE barcode="APAT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 7 DAY) WHERE barcode="APAT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 8 DAY) WHERE barcode="APAT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 5 DAY) WHERE barcode="APBT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 6 DAY) WHERE barcode="APBT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 7 DAY) WHERE barcode="APBT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 7 DAY) WHERE barcode="CAAT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 8 DAY) WHERE barcode="CAAT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 9 DAY) WHERE barcode="CAAT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 6 DAY) WHERE barcode="CABT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 7 DAY) WHERE barcode="CABT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 8 DAY) WHERE barcode="CABT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 5 DAY) WHERE barcode="CPAT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 6 DAY) WHERE barcode="CPAT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 7 DAY) WHERE barcode="CPAT3"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 4 DAY) WHERE barcode="CPBT1"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 5 DAY) WHERE barcode="CPBT2"; UPDATE issues JOIN items USING (itemnumber) SET date_due = DATE_SUB(NOW(),INTERVAL 6 DAY) WHERE barcode="CPBT3"; perl misc/cronjobs/overdue_notices.pl -v -v -n -t --library MPL --test --borcat PT --borcat PT2 --frombranch patron-homebranch run with branch MPL and CPL - there is a bug related to patron-homebranch where notices aren't fully populated, but is unrelated to these patches, I filed a bug here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43405 -- You are receiving this mail because: You are watching all bug changes.