https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32017 Bug ID: 32017 Summary: Database update makes returned items show as checked out in circulation history 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: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com The database update for 20.11.03 caues 2 issues: * It updated the timestamp to the time of the update and didn't preserve the previous one. * The NULL values show up in the circulation history as still checked out, I asusme the template checks for content of the field after doing a union of issues and old issues. And an emptry returndate = still checked out (staff interface) The NULL is ok, the timestamp can't be saved... but we could make the template smarter. $DBversion = '20.11.03.002'; if( CheckVersion( $DBversion ) ) { sanitize_zero_date('aqorders', 'datecancellationprinted'); sanitize_zero_date('old_issues', 'returndate'); NewVersion( $DBversion, 7806, "Remove remaining possible 0000-00-00 values"); } -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.