From 492d49eb08bc8b7ecec1c75d7d7f9fdad3b1186f Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Tue, 13 Jan 2015 20:33:36 +0000
Subject: Fix MySQL and PGSQL *UserProfilesData.GetUserAppData() calls to
 correctly set the UserId parameter instead of the non-existing Id parameter
 when writing a record because none yet exists.

SQLite version is already correct for this.
---
 OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 2 +-
 OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
index 1f616fe..86f2efe 100644
--- a/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
+++ b/OpenSim/Data/MySQL/MySQLUserProfilesData.cs
@@ -1022,7 +1022,7 @@ namespace OpenSim.Data.MySQL
                                 
                                 using (MySqlCommand put = new MySqlCommand(query, dbcon))
                                 {
-                                    put.Parameters.AddWithValue("?Id", props.UserId.ToString());
+                                    put.Parameters.AddWithValue("?UserId", props.UserId.ToString());
                                     put.Parameters.AddWithValue("?TagId", props.TagId.ToString());
                                     put.Parameters.AddWithValue("?DataKey", props.DataKey.ToString());
                                     put.Parameters.AddWithValue("?DataVal", props.DataVal.ToString());
diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
index e799eb8..0f4c8c1 100644
--- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
+++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
@@ -999,7 +999,7 @@ namespace OpenSim.Data.PGSQL
                                 
                                 using (NpgsqlCommand put = new NpgsqlCommand(query, dbcon))
                                 {
-                                    put.Parameters.Add(m_database.CreateParameter("Id", props.UserId));
+                                    put.Parameters.Add(m_database.CreateParameter("UserId", props.UserId));
                                     put.Parameters.Add(m_database.CreateParameter("TagId", props.TagId));
                                     put.Parameters.Add(m_database.CreateParameter("DataKey", props.DataKey.ToString()));
                                     put.Parameters.Add(m_database.CreateParameter("DataVal", props.DataVal.ToString()));
-- 
cgit v1.1