From 02f2352ad5ba4b60638ad85f8449a0cb336ce1a0 Mon Sep 17 00:00:00 2001
From: Justin Clark-Casey (justincc)
Date: Tue, 13 Jan 2015 23:52:52 +0000
Subject: Fix PGSQLUserProfilesData.GetUserPreferences error when no
 usersettings yet exist by inserting missing ID parameter.

Relates to http://opensimulator.org/mantis/view.php?id=7398
---
 OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs | 1 +
 1 file changed, 1 insertion(+)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
index ade12bf..301d3dd 100644
--- a/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
+++ b/OpenSim/Data/PGSQL/PGSQLUserProfilesData.cs
@@ -904,6 +904,7 @@ namespace OpenSim.Data.PGSQL
                             {
                                 using (NpgsqlCommand put = new NpgsqlCommand(query, dbcon))
                                 {
+                                    put.Parameters.Add(m_database.CreateParameter("Id", pref.UserId));
                                     query = "INSERT INTO usersettings VALUES ";
                                     query += "(:Id,'false','false', '')";
 
-- 
cgit v1.1