aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
authorDiva Canto2016-06-17 12:40:04 -0700
committerDiva Canto2016-06-17 12:40:04 -0700
commit8a070f16ddf49f72dbb925b87f3ae78d4323894e (patch)
tree5bfd395de5cab01da6ec9382d5bc80960f8c6acb /OpenSim/Data/MySQL
parent"reverting" the keep alive changes brought in from avination, to check if tha... (diff)
downloadopensim-SC_OLD-8a070f16ddf49f72dbb925b87f3ae78d4323894e.zip
opensim-SC_OLD-8a070f16ddf49f72dbb925b87f3ae78d4323894e.tar.gz
opensim-SC_OLD-8a070f16ddf49f72dbb925b87f3ae78d4323894e.tar.bz2
opensim-SC_OLD-8a070f16ddf49f72dbb925b87f3ae78d4323894e.tar.xz
Mantis #7848: something wrong with a data field in Groups V2
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/MySQLGroupsData.cs3
1 files changed, 1 insertions, 2 deletions
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
431 431
432 using (MySqlCommand cmd = new MySqlCommand()) 432 using (MySqlCommand cmd = new MySqlCommand())
433 { 433 {
434 cmd.CommandText = String.Format("delete from {0} where TMStamp < ?tstamp", m_Realm); 434 cmd.CommandText = String.Format("delete from {0} where TMStamp < NOW() - INTERVAL 2 WEEK", m_Realm);
435 cmd.Parameters.AddWithValue("?tstamp", now - 14 * 24 * 60 * 60); // > 2 weeks old
436 435
437 ExecuteNonQuery(cmd); 436 ExecuteNonQuery(cmd);
438 } 437 }