[Koha-bugs] [Bug 6868] New: Need a script to fix bad accountno data in accountlines
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Sep 14 20:39:35 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6868
Bug #: 6868
Summary: Need a script to fix bad accountno data in
accountlines
Classification: Unclassified
Change sponsored?: ---
Product: Koha
Version: rel_3_6
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P5
Component: Patrons
AssignedTo: kyle.m.hall at gmail.com
ReportedBy: wizzyrea at gmail.com
QAContact: koha-bugs at lists.koha-community.org
CC: gmcharlt at gmail.com
A pretty serious, and heretofore unidentified bug was causing the
accountlines.accountno to increment based on the max accountno in the entire
accountlines table. This would cause the SMALL_INT to reach max far more
quickly than it should have. The bug that caused the problem was fixed with the
patch that was submitted and pushed for bug 3498, but that wouldn't repair the
problem in the data - each borrowernumber should have 32767 lines available to
it, but in all databases that have been privy to this bug, that wouldn't be
correct - numbers would have been skipped based on the max accountno at the
time of the writeoff.
What is needed is a script to clean up the accountno for each borrower, to
increment it correctly and free all remaining available lines for each
borrower.
--
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
More information about the Koha-bugs
mailing list