[Koha-bugs] [Bug 3168] `accountlines.accountno` is SMALL-INT, and maxs too quickly

Thu Feb 9 21:00:03 CET 2012

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

Fred P <fred.pierre at smfpl.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fred.pierre at smfpl.org

--- Comment #3 from Fred P <fred.pierre at smfpl.org> 2012-02-09 20:00:03 UTC ---
Updating to Koha 3.6 will prevent future problems, but libraries where patrons
already have several accountlines with accountno 32767 (due to previous Koha
writeoff bug) may still experience problems. At our library we currently have
more than 319,000 accountlines set to accountno 32767!

When making a payment, several lines may disappear from the pay fines table,
because the process intended to act on one line, actually affects all lines
with accountno 32767. 

Jorge is authoring a cleanup script that will rewrite accountlines for each
patron with sequential accountno's starting at 1. That will reset all 32767
lines to proper sequential values. Will post as soon as it's ready!

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.