https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41967
--- Comment #6 from Ayoub Glizi-Vicioso <[email protected]> --- Created attachment 194551 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=194551&action=edit Bug 41967: Ensure --cards argument accepts an integer in cleanup_database.pl Test plan (for --cards arguments) : 1. Initial Setup: a) Go to Tools > Patron card creator > New > Card batch b) Create two different batches (Batch 1 and Batch 2) using the 'Add by borrowernumber(s):' option. If using **KTD** you can use the following borrowernumbers for both batches: 15 29 47 else you will need to create your own patrons and enter their borrowernumber. c) In your terminal, set the timestamps manually: --OPTION A (KTD users): ktd --shell koha-mysql kohadev --OPTION B: Access your database Then: UPDATE creator_batches SET timestamp = DATE_SUB(NOW(), INTERVAL 30 DAY) WHERE batch_id = '1'; UPDATE creator_batches SET timestamp = DATE_SUB(NOW(), INTERVAL 5 DAY) WHERE batch_id = '2'; Note: your batch_id may differ. 2. Before Applying the Patch: a) Run the following cleanup script: ./misc/cronjobs/cleanup_database.pl --cards 15 --confirm --verbose b) Check that the console output says: "Purging ... more than 1 days ago" c) Check database and notice that it is now empty, even though one set was less than 15 days old. SELECT * FROM creator_batches; 3. Apply The Patch 4. After Applying The Patch: a) Redo step 1 (Initial Setup). b) Run again the following cleanup script: ./misc/cronjobs/cleanup_database.pl --cards 15 --confirm --verbose c) Check that the console output says: "Purging ... more than 15 days ago" d) Batch 1 is deleted, but Batch 2 (5 days old) is STILL PRESENT. Success! SELECT * FROM creator_batches; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://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/
