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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
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/
