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/SQLite/SQLiteGridUserData.cs | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'OpenSim/Data/SQLite/SQLiteGridUserData.cs')

diff --git a/OpenSim/Data/SQLite/SQLiteGridUserData.cs b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
index 1bb5ed8..54cef1a 100644
--- a/OpenSim/Data/SQLite/SQLiteGridUserData.cs
+++ b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
@@ -56,6 +56,10 @@ namespace OpenSim.Data.SQLite
             return ret[0];
         }
 
+        public GridUserData[] GetAll(string userID)
+        {
+            return base.Get("UserID LIKE {0}%", userID);
+        }
 
     }
 }
\ No newline at end of file
-- 
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/SQLite/SQLiteGridUserData.cs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/SQLite/SQLiteGridUserData.cs')

diff --git a/OpenSim/Data/SQLite/SQLiteGridUserData.cs b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
index 54cef1a..799df91 100644
--- a/OpenSim/Data/SQLite/SQLiteGridUserData.cs
+++ b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
@@ -58,7 +58,7 @@ namespace OpenSim.Data.SQLite
 
         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/SQLite/SQLiteGridUserData.cs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'OpenSim/Data/SQLite/SQLiteGridUserData.cs')

diff --git a/OpenSim/Data/SQLite/SQLiteGridUserData.cs b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
index 799df91..d8c52f8 100644
--- a/OpenSim/Data/SQLite/SQLiteGridUserData.cs
+++ b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
@@ -58,7 +58,7 @@ namespace OpenSim.Data.SQLite
 
         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