https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42218 --- Comment #55 from Nick Clemens (kidclamp) <nick@bywatersolutions.com> --- Created attachment 211481 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=211481&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> Signed-off-by: Nick Clemens <nick@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.