diff options
| author | Justin Clark-Casey (justincc) | 2015-01-13 20:33:36 +0000 |
|---|---|---|
| committer | Justin Clark-Casey (justincc) | 2015-01-13 20:33:36 +0000 |
| commit | 492d49eb08bc8b7ecec1c75d7d7f9fdad3b1186f (patch) | |
| tree | 2b6a9b195b304d5a90b64526447ed0188cd869bf | |
| parent | Remove quotes from column selection in PGSQLUserProfilesData.SetUserAppData() (diff) | |
| download | opensim-SC-492d49eb08bc8b7ecec1c75d7d7f9fdad3b1186f.zip opensim-SC-492d49eb08bc8b7ecec1c75d7d7f9fdad3b1186f.tar.gz opensim-SC-492d49eb08bc8b7ecec1c75d7d7f9fdad3b1186f.tar.bz2 opensim-SC-492d49eb08bc8b7ecec1c75d7d7f9fdad3b1186f.tar.xz | |
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.
| -rw-r--r-- | OpenSim/Data/MySQL/MySQLUserProfilesData.cs | 2 | ||||
| -rw-r--r-- | 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 | |||
| 1022 | 1022 | ||
| 1023 | using (MySqlCommand put = new MySqlCommand(query, dbcon)) | 1023 | using (MySqlCommand put = new MySqlCommand(query, dbcon)) |
| 1024 | { | 1024 | { |
| 1025 | put.Parameters.AddWithValue("?Id", props.UserId.ToString()); | 1025 | put.Parameters.AddWithValue("?UserId", props.UserId.ToString()); |
| 1026 | put.Parameters.AddWithValue("?TagId", props.TagId.ToString()); | 1026 | put.Parameters.AddWithValue("?TagId", props.TagId.ToString()); |
| 1027 | put.Parameters.AddWithValue("?DataKey", props.DataKey.ToString()); | 1027 | put.Parameters.AddWithValue("?DataKey", props.DataKey.ToString()); |
| 1028 | put.Parameters.AddWithValue("?DataVal", props.DataVal.ToString()); | 1028 | 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 | |||
| 999 | 999 | ||
| 1000 | using (NpgsqlCommand put = new NpgsqlCommand(query, dbcon)) | 1000 | using (NpgsqlCommand put = new NpgsqlCommand(query, dbcon)) |
| 1001 | { | 1001 | { |
| 1002 | put.Parameters.Add(m_database.CreateParameter("Id", props.UserId)); | 1002 | put.Parameters.Add(m_database.CreateParameter("UserId", props.UserId)); |
| 1003 | put.Parameters.Add(m_database.CreateParameter("TagId", props.TagId)); | 1003 | put.Parameters.Add(m_database.CreateParameter("TagId", props.TagId)); |
| 1004 | put.Parameters.Add(m_database.CreateParameter("DataKey", props.DataKey.ToString())); | 1004 | put.Parameters.Add(m_database.CreateParameter("DataKey", props.DataKey.ToString())); |
| 1005 | put.Parameters.Add(m_database.CreateParameter("DataVal", props.DataVal.ToString())); | 1005 | put.Parameters.Add(m_database.CreateParameter("DataVal", props.DataVal.ToString())); |