From 57b13cd84f3b5c767d07fb2a5a83cc1810567e4b Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Fri, 11 Oct 2019 12:26:11 -0400
Subject: [PATCH] from ws6

---
 Toolkit/Common.php | 2 +-
 config/server.ini  | 2 +-
 setup.phtml        | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/Toolkit/Common.php b/Toolkit/Common.php
index 2ff5197..a68a1ea 100644
--- a/Toolkit/Common.php
+++ b/Toolkit/Common.php
@@ -849,7 +849,7 @@ class Toolkit_Common
                 SELECT *
                   FROM connectby('{$table}', '{$key}', '{$parent}',
                                  '{$order}', '{$start}', {$maxDepth})
-                        as t(id text, parent text, level int, pos int)";
+                        as t(id int, parent int, level int, pos int)";
             if ($validParent) {
                  $sql .= " WHERE parent is not null";
             }
diff --git a/config/server.ini b/config/server.ini
index 80d4d45..0f6ae57 100644
--- a/config/server.ini
+++ b/config/server.ini
@@ -79,7 +79,7 @@ database.adapter         = "pgsql"
 ; error message displayed - used for GLM_DB class
 database.error.message   = "An error has occured with the database!"
 ; host to connect to
-database.params.host     = "ds4"
+database.params.host     = "ds5"
 ; username to connect as
 database.params.username = "nobody"
 ; database name to connect to
diff --git a/setup.phtml b/setup.phtml
index de10b5b..6744909 100644
--- a/setup.phtml
+++ b/setup.phtml
@@ -1180,7 +1180,7 @@ if (!file_exists($SiteCheckFile) && $_ENV['GLM_HOST_ID'] == 'PRODUCTION') {
             . "/**\n"
             . " * GLM Standard Site Monitoring Target\n"
             . " */\n\n"
-            . "define('HOST',   'ds4.gaslightmedia.com');\n"
+            . "define('HOST',   'ds5.gaslightmedia.com');\n"
             . "define('USER',   'nobody');\n"
             . "define('DBNAME', '$dbname');\n"
             . "\n"
-- 
2.17.1