Bug 15312

Summary: Make fix_accountlines_date.pl handle all date formats
Product: Koha Reporter: Marc Véron <veron>
Component: Fines and feesAssignee: Galen Charlton <gmcharlt>
Status: RESOLVED INVALID QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: katrin.fischer
Version: Main   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15310
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15076
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13104
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Marc Véron 2015-12-04 18:40:12 UTC
Changing the sysprefs 'dateformat' and/or 'TimeFormat' on a production server with overdue items that is accruing fines can result in duplicate fines.

Reason: The date is stored in syspref format in the table accountlines,  description field and parsed is from there.

Until we have a rewrite of the accounts system ready, the script 
fix_accountlines_date.pl can be used to parse and change the date format. 

However it handles only 'us' and 'metric' as previous date formats.
Comment 1 Marc Véron 2015-12-04 19:16:32 UTC
...and it does not touch the time format at all. Changing the time format can result in duplicate fines as well.
Comment 2 Katrin Fischer 2023-08-28 20:05:10 UTC
> Until we have a rewrite of the accounts system ready, the script 
> fix_accountlines_date.pl can be used to parse and change the date format. 

I believe this has happened since :)