http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8253

--- Comment #1 from Kyle M Hall <kyle.m.h...@gmail.com> ---
Created attachment 10369
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=10369&action=edit
Bug 8253 - Fine doubling

This issue only occurs when upgrading from pre-3.8 to post 3.8 Koha.

The issue is caused by the change from dates to datetimes that was
neccesary to implement hourly loans. All pre-3.8 fines have the date
in the description. This date is how the fines script know which fine
to update. If the fine script does not locate an existing row to update,
it creates a new row.

The switch from dates to datetimes means the fines script now looks
for a format such as 'YYYY-MM-DD 00:00' ( for iso ), but all the previous
fines are still in the format 'YYYY-MM-DD' and so it fails to find
the matching row, and creates a new row instead.

This commit consists of a database update that alters the dates
in the accountlines description field to be datetimes instead. This
eliminates future fine doubling. It is also safe to run on a system
that has been previously upgraded, it will ignore any rows where
the date is already of the format 'YYYY-MM-DD 00:00' ( or whichever
date format you have chosen ).

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://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/

Reply via email to