[Koha-bugs] [Bug 29902] New: While upgrading all empty deleteditems.datelastborrowed turned deleteditems.timestamp to date of upgrade

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29902

            Bug ID: 29902
           Summary: While upgrading all empty
                    deleteditems.datelastborrowed turned
                    deleteditems.timestamp to date of upgrade
 Change sponsored?: ---
           Product: Koha
           Version: 19.05
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Installation and upgrade (command-line installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: edv at hoernergruppe.de
        QA Contact: testopia at bugs.koha-community.org

After upgrading from 19.06 to latest we recognized in our deleted items report
a wrong amount of deleted items for 2021.
Digging onto the problem we found, that every dataset in deleteditems with an
empty deleteditems.datelastborrowed field, caused a deleteditems.timestamp set
to the actual date by overwriting the former content of the field.
We got the former content back by importing additionally the old database so
called "koha_library_old" and the follwing SQL request (2021-12-01 was the date
of our upgrade)
UPDATE koha_library.deleteditems, koha_library_old.deleteditems SET
koha_library.deleteditems.timestamp = koha_library_old.deleteditems.timestamp
WHERE koha_library.deleteditems.barcode = koha_library_old.deleteditems.barcode
AND koha_library.deleteditems.timestamp LIKE '2021-12-01%';

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.