From e984bfb4c63718d5176b17f6beea46f4512cf304 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Tue, 2 Jul 2013 14:31:39 -0700
Subject: This should have a strong effect on the Unknown User issue mantis
 #6625

---
 OpenSim/Data/MSSQL/MSSQLGridUserData.cs | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'OpenSim/Data/MSSQL/MSSQLGridUserData.cs')

diff --git a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
index 9e215f9..df73e5b 100644
--- a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
@@ -50,7 +50,7 @@ namespace OpenSim.Data.MSSQL
         {
         }
 
-        public GridUserData Get(string userID)
+        public new GridUserData Get(string userID)
         {
             GridUserData[] ret = Get("UserID", userID);
 
@@ -60,5 +60,10 @@ namespace OpenSim.Data.MSSQL
             return ret[0];
         }
 
+        public GridUserData[] GetAll(string userID)
+        {
+            return base.Get("UserID LIKE {0}%", userID);
+        }
+
     }
 }
-- 
cgit v1.1


From 9725b829d5e476fc6b0894b46520ff1d7aba9936 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Tue, 2 Jul 2013 15:48:30 -0700
Subject: Do the same for SQLite and MSSQL

---
 OpenSim/Data/MSSQL/MSSQLGridUserData.cs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/MSSQL/MSSQLGridUserData.cs')

diff --git a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
index df73e5b..7d10955 100644
--- a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
@@ -62,7 +62,7 @@ namespace OpenSim.Data.MSSQL
 
         public GridUserData[] GetAll(string userID)
         {
-            return base.Get("UserID LIKE {0}%", userID);
+            return base.Get(String.Format("UserID LIKE {0}%", userID));
         }
 
     }
-- 
cgit v1.1


From 316e8f92391f561d459bc6240ccd78b0a98c20c6 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Tue, 2 Jul 2013 16:10:09 -0700
Subject: Fix SQL statement

---
 OpenSim/Data/MSSQL/MSSQLGridUserData.cs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/MSSQL/MSSQLGridUserData.cs')

diff --git a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
index 7d10955..8ec8d49 100644
--- a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
@@ -62,7 +62,7 @@ namespace OpenSim.Data.MSSQL
 
         public GridUserData[] GetAll(string userID)
         {
-            return base.Get(String.Format("UserID LIKE {0}%", userID));
+            return base.Get(String.Format("UserID LIKE '{0}%'", userID));
         }
 
     }
-- 
cgit v1.1