From 2fe7eb9af5e80da091bc7edd6bd91d883b701585 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Sun, 11 Nov 2007 16:29:10 -0600 Subject: [PATCH] Making SQL more portable Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- updater/updatedatabase | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/updater/updatedatabase b/updater/updatedatabase index cae90eef0a..2ca1b0860c 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -563,7 +563,8 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $DBversion = "3.00.00.023"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { - $dbh->do("INSERT INTO `systempreferences` VALUES ('yuipath','http://yui.yahooapis.com/2.3.1/build','Insert the path to YUI libraries','','free')"); + $dbh->do("INSERT INTO `systempreferences` (variable,value,options,explanation,type) + VALUES ('yuipath','http://yui.yahooapis.com/2.3.1/build','Insert the path to YUI libraries','','free')"); print "Upgrade to $DBversion done (adding new system preference for controlling YUI path)\n"; SetVersion ($DBversion); } -- 2.39.5