[Koha-bugs] [Bug 2594] New: create_koc_db.pl Not functioning correctly.
bugzilla-daemon at pippin.metavore.com
bugzilla-daemon at pippin.metavore.com
Tue Sep 9 15:18:10 CEST 2008
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2594
Summary: create_koc_db.pl Not functioning correctly.
Product: Koha
Version: rel_3_0
Platform: PC
OS/Version: All
Status: NEW
Severity: normal
Priority: P3
Component: Circulation
AssignedTo: Andrew.moore at liblime.com
ReportedBy: kyle.m.hall at gmail.com
QAContact: koha-bugs at lists.koha.org
The borrowers.db file only contains the borrowernumber for each patron, instead
of the entire row.
I opened up create_koc_db.pl and on line 209 I see:
SELECT borrowers.borrowernumber, sum( accountlines.amountoutstanding )
as total_fines
I think if it were changed to:
SELECT *, sum( accountlines.amountoutstanding ) as total_fines
That should fix it. At least for the borrowers side of things.
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.
More information about the Koha-bugs
mailing list