aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL
diff options
context:
space:
mode:
authorCharles Krinke2008-07-12 18:05:57 +0000
committerCharles Krinke2008-07-12 18:05:57 +0000
commit932ed5ec549ff3f6c4ea50963f9be1d9902e446b (patch)
treefa0cd300350e5383b9bb09100a9ddf1b59b102f9 /OpenSim/Data/MSSQL
parentMantis#1681. Thank you kindly, Vytek for a patch that: (diff)
downloadopensim-SC-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.zip
opensim-SC-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.tar.gz
opensim-SC-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.tar.bz2
opensim-SC-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.tar.xz
Mantis#1726. Thank you kindly, StrawberryFride for a patch that:
On an MSSQL-based Grid OpenSim installation, users could log in to the sim once, then log off - after a short time before retrying users would be unable to log in, and would see an empty alert box on the client with just a "close" button and no text. Despite no users being logged into the sim, user server would report a higher number of logins than logouts.
Diffstat (limited to 'OpenSim/Data/MSSQL')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLGridData.cs4
1 files changed, 4 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLGridData.cs b/OpenSim/Data/MSSQL/MSSQLGridData.cs
index e2b0dd6..1ed412b 100644
--- a/OpenSim/Data/MSSQL/MSSQLGridData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGridData.cs
@@ -149,6 +149,10 @@ namespace OpenSim.Data.MSSQL
149 IDataReader reader = null; 149 IDataReader reader = null;
150 try 150 try
151 { 151 {
152 if (database.getConnection().State == ConnectionState.Closed)
153 {
154 database.Reconnect();
155 }
152 Dictionary<string, string> param = new Dictionary<string, string>(); 156 Dictionary<string, string> param = new Dictionary<string, string>();
153 param["handle"] = handle.ToString(); 157 param["handle"] = handle.ToString();
154 IDbCommand result = database.Query("SELECT * FROM " + m_regionsTableName + " WHERE regionHandle = @handle", param); 158 IDbCommand result = database.Query("SELECT * FROM " + m_regionsTableName + " WHERE regionHandle = @handle", param);