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@liblime.com ReportedBy: kyle.m.hall@gmail.com QAContact: koha-bugs@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.