Bug 15312 - Make fix_accountlines_date.pl handle all date formats
Summary: Make fix_accountlines_date.pl handle all date formats
Status: RESOLVED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Fines and fees (show other bugs)
Version: Main
Hardware: All All
: P5 - low minor (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-12-04 18:40 UTC by Marc Véron
Modified: 2023-08-28 20:05 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 :)