From 8a070f16ddf49f72dbb925b87f3ae78d4323894e Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Fri, 17 Jun 2016 12:40:04 -0700
Subject: Mantis #7848: something wrong with a data field in Groups V2
---
OpenSim/Data/MySQL/MySQLGroupsData.cs | 3 +--
1 file changed, 1 insertion(+), 2 deletions(-)
(limited to 'OpenSim/Data/MySQL')
diff --git a/OpenSim/Data/MySQL/MySQLGroupsData.cs b/OpenSim/Data/MySQL/MySQLGroupsData.cs
index afa499e..5734d19 100644
--- a/OpenSim/Data/MySQL/MySQLGroupsData.cs
+++ b/OpenSim/Data/MySQL/MySQLGroupsData.cs
@@ -431,8 +431,7 @@ namespace OpenSim.Data.MySQL
using (MySqlCommand cmd = new MySqlCommand())
{
- cmd.CommandText = String.Format("delete from {0} where TMStamp < ?tstamp", m_Realm);
- cmd.Parameters.AddWithValue("?tstamp", now - 14 * 24 * 60 * 60); // > 2 weeks old
+ cmd.CommandText = String.Format("delete from {0} where TMStamp < NOW() - INTERVAL 2 WEEK", m_Realm);
ExecuteNonQuery(cmd);
}
--
cgit v1.1