From 00f35d2fde82a2ab14986db2036da51040205180 Mon Sep 17 00:00:00 2001 From: Andrew Moore Date: Tue, 9 Sep 2008 12:51:35 -0500 Subject: [PATCH] bug 2594: fixing SQL statement to populate patron information in offline circulation db 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. Signed-off-by: Galen Charlton --- misc/cronjobs/create_koc_db.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/misc/cronjobs/create_koc_db.pl b/misc/cronjobs/create_koc_db.pl index c1baa50a48..ab5c7f2669 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 -- 2.39.2