https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42218 --- Comment #52 from Pedro Amorim (ammopt) <pedro.amorim@openfifth.co.uk> --- Created attachment 211231 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=211231&action=edit Bug 42218: (RM follow-up) Rebuild existing yearly usage Yearly usage stored before the upgrade keeps its old totals until it is imported again. Rebuild erm_usage_yus from erm_usage_mus once, with the same sum as YearlyUsages->rebuild. Test plan: 1) Before applying the patch, upload a COUNTER file for a usage data provider (e.g. attachment 210115 on bug 42217) 2) UPDATE erm_usage_yus SET totalcount = totalcount + 100; 3) SELECT (SELECT SUM(totalcount) FROM erm_usage_yus), (SELECT SUM(usage_count) FROM erm_usage_mus); Confirm the two numbers differ 4) Apply the patch and run updatedatabase 5) Repeat step 3 and confirm the two numbers are equal Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com> -- You are receiving this mail because: You are watching all bug changes.