https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41307
--- Comment #30 from Clemens Tubach <[email protected]> --- Created attachment 210264 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=210264&action=edit Bug 41307: Tell administrators to run the counter data migration script The atomicupdate adds the status, report type and report period columns to erm_counter_logs. It does not change any existing row. The counter log rows written before this patch have no report type and no period, so the data providers summary skips every month harvested before the upgrade. Re-harvests before Bug 42217 also left duplicated rows in erm_usage_mus, which double the yearly totals. The script misc/maintenance/erm_migrate_counter_data.pl, added by the next patch, fixes both. The atomicupdate ends with a message that names it, so the upgrade does not have to read every stored counter file. Test plan: 1. On a database from before this patch, run updatedatabase: the columns, the index and the foreign key are added, and a message tells you to run misc/maintenance/erm_migrate_counter_data.pl 2. Check that no row of erm_counter_logs or erm_usage_mus has changed Assisted-by: Sonnet 5.5 (Anthropic) Signed-off-by: Clemens Tubach <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected] website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
