diff options
Diffstat (limited to 'OpenSim/Data/MySQL/MySQLLegacyRegionData.cs')
-rw-r--r-- | OpenSim/Data/MySQL/MySQLLegacyRegionData.cs | 20 |
1 files changed, 14 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs b/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs index 839ac7f..6bc8bec 100644 --- a/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs +++ b/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs | |||
@@ -68,12 +68,20 @@ namespace OpenSim.Data.MySQL | |||
68 | 68 | ||
69 | // Clean dropped attachments | 69 | // Clean dropped attachments |
70 | // | 70 | // |
71 | MySqlCommand cmd = m_Connection.CreateCommand(); | 71 | try |
72 | cmd.CommandText = "delete from prims, primshapes using prims " + | 72 | { |
73 | "left join primshapes on prims.uuid = primshapes.uuid " + | 73 | using (MySqlCommand cmd = m_Connection.CreateCommand()) |
74 | "where PCode = 9 and State <> 0"; | 74 | { |
75 | ExecuteNonQuery(cmd); | 75 | cmd.CommandText = "delete from prims, primshapes using prims " + |
76 | cmd.Dispose(); | 76 | "left join primshapes on prims.uuid = primshapes.uuid " + |
77 | "where PCode = 9 and State <> 0"; | ||
78 | ExecuteNonQuery(cmd); | ||
79 | } | ||
80 | } | ||
81 | catch (MySqlException ex) | ||
82 | { | ||
83 | m_log.Error("[REGION DB]: Error cleaning up dropped attachments: " + ex.Message); | ||
84 | } | ||
77 | } | 85 | } |
78 | 86 | ||
79 | private IDataReader ExecuteReader(MySqlCommand c) | 87 | private IDataReader ExecuteReader(MySqlCommand c) |