https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41967
--- Comment #2 from Ayoub Glizi-Vicioso <[email protected]> --- Created attachment 194415 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=194415&action=edit Bug 41967: Ensure --labels argument accepts an integer in cleanup_database.pl Test plan : 1. Initial Setup: a) Go to Cataloging > Label creator > New > Label batch b) Create two different batches (Batch 1 and Batch 2) using the 'Add by barcodes or itemnumbers' option. If using **KTD** you can use those barcodes for the two batches: 39999000010114 39999000010138 39999000010152 else you will need to create your own records with items and enter their barcodes. c) In your terminal (in a ktd --shell), 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 --labels 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 --labels 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 watching all bug changes. You are the assignee for the bug. _______________________________________________ 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/
