[Koha-patches] [PATCH 10/11] Fixing updatedatabase DBRev 130 debarred

Henri-Damien LAURENT henridamien.laurent at biblibre.com
Fri Mar 26 11:25:40 CET 2010


call to selectall_arrayref was erroneous
use call to selectcol_arrayref in order to do the updatedatabase

Signed-off-by: Henri-Damien LAURENT <henridamien.laurent at biblibre.com>
---
 installer/data/mysql/updatedatabase.pl |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index e5f6c22..6a289e7 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -3593,7 +3593,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
 
 $DBversion = "3.01.00.130";
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
-	my $borrowers=$dbh->selectall_arrayref("SELECT borrowernumber from borrowers where debarred <>0;",[0]);
+	my $borrowers=$dbh->selectcol_arrayref("SELECT borrowernumber from borrowers where debarred <>0;",{Columns=>[1]});
 	$dbh->do("ALTER TABLE borrowers MODIFY debarred DATE DEFAULT NULL;");
 	$dbh->do("UPDATE borrowers set debarred='9999-12-31' where borrowernumber IN (".join (",",@$borrowers).");");
 	$dbh->do("ALTER TABLE borrowers ADD COLUMN debarredcomment VARCHAR(255) DEFAULT NULL AFTER debarred;");
-- 
1.6.3.3




More information about the Koha-patches mailing list