[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