https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26026 Bug ID: 26026 Summary: cleanup_database does not allow to purge data created today Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs@lists.koha-community.org Reporter: jonathan.druart@bugs.koha-community.org QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz The query is built with WHERE expiration < date_sub(CURDATE(), INTERVAL ? DAY), which truncate to day MariaDB [koha_kohadev]> SELECT DATE_SUB(CURDATE(), INTERVAL 0 DAY); +-------------------------------------+ | DATE_SUB(CURDATE(), INTERVAL 0 DAY) | +-------------------------------------+ | 2020-07-20 | +-------------------------------------+ It makes it impossible to remove the data from today. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.