diff options
| author | Diva Canto | 2016-06-17 12:40:04 -0700 |
|---|---|---|
| committer | Diva Canto | 2016-06-17 12:40:04 -0700 |
| commit | 8a070f16ddf49f72dbb925b87f3ae78d4323894e (patch) | |
| tree | 5bfd395de5cab01da6ec9382d5bc80960f8c6acb /OpenSim/Data/MySQL | |
| parent | "reverting" the keep alive changes brought in from avination, to check if tha... (diff) | |
| download | opensim-SC-8a070f16ddf49f72dbb925b87f3ae78d4323894e.zip opensim-SC-8a070f16ddf49f72dbb925b87f3ae78d4323894e.tar.gz opensim-SC-8a070f16ddf49f72dbb925b87f3ae78d4323894e.tar.bz2 opensim-SC-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.cs | 3 |
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 | } |