[Koha-bugs] [Bug 8253] Fine doubling

[bugzilla-daemon at bugs.koha-community.org]

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

Kyle M Hall <kyle at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #11087|0                           |1
        is obsolete|                            |

--- Comment #10 from Kyle M Hall <kyle at bywatersolutions.com> ---
Created attachment 11127
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11127&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 HH:MM' ( or whichever
date format you have chosen ).

The second part of this update will remove any existing duplicate fines
that have been created as a result of this error.

-- 
You are receiving this mail because:
You are watching all bug changes.