From c6086ad8bca418c424a028b1d9e2e2f2187f785a Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Sun, 27 Jan 2008 13:17:30 -0600 Subject: [PATCH] Fix for bug in updatedatabase (extra comma) (fixed by Chris Nighswonger) Signed-off-by: Joshua Ferraro --- installer/data/mysql/updatedatabase.pl | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 63c4634f36..33ad8c69c7 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -962,17 +962,15 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = "3.00.00.049"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("ALTER TABLE `z3950servers` - ADD `encoding` text default NULL, - "); - print "Upgrade to $DBversion done ( Added encoding field to z3950servers table )\n"; + $dbh->do("ALTER TABLE `z3950servers` ADD `encoding` text default NULL "); + print "Upgrade to $DBversion done ( Added encoding field to z3950servers table )\n"; SetVersion ($DBversion); } $DBversion = "3.00.00.050"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacHighlightedWords','0','If Set, query matched terms are highlighted in OPAC',NULL,'YesNo');"); - print "Upgrade to $DBversion done ( Added OpacHighlightedWords syspref )\n"; + print "Upgrade to $DBversion done ( Added OpacHighlightedWords syspref )\n"; SetVersion ($DBversion); } -- 2.39.5