[Koha-patches] [PATCH] bug 2594: fixing SQL statement to populate patron information in offline circulation db

[Andrew Moore]

The offline circulation tool can use all of the patron information, not just their ID
numbers. This patch populates the offline circulation database with patron information.
---
 misc/cronjobs/create_koc_db.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/misc/cronjobs/create_koc_db.pl b/misc/cronjobs/create_koc_db.pl
index c1baa50..ab5c7f2 100755
--- a/misc/cronjobs/create_koc_db.pl
+++ b/misc/cronjobs/create_koc_db.pl
@@ -206,7 +206,7 @@ sub populate_borrowers_table {
     my $sth_sqlite = $dbh_sqlite->prepare($sql);
 
     my $sth_mysql    = $dbh_mysql->prepare(<<'END_SQL');
-SELECT borrowers.borrowernumber, sum( accountlines.amountoutstanding ) as total_fines
+SELECT borrowers.*, sum( accountlines.amountoutstanding ) as total_fines
 FROM borrowers
 LEFT JOIN accountlines
   ON borrowers.borrowernumber = accountlines.borrowernumber
-- 
1.5.6