From 9211361b19d84a266b98f0db1105721b49bfb3c7 Mon Sep 17 00:00:00 2001 From: Oren Hurvitz Date: Wed, 2 Apr 2014 10:00:09 +0300 Subject: Fixed AssetsExist in SQLite --- OpenSim/Data/SQLite/SQLiteAssetData.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/OpenSim/Data/SQLite/SQLiteAssetData.cs b/OpenSim/Data/SQLite/SQLiteAssetData.cs index 1f32376..2834bcf 100644 --- a/OpenSim/Data/SQLite/SQLiteAssetData.cs +++ b/OpenSim/Data/SQLite/SQLiteAssetData.cs @@ -226,11 +226,11 @@ namespace OpenSim.Data.SQLite HashSet exist = new HashSet(); string ids = "'" + string.Join("','", uuids) + "'"; - string sql = string.Format("SELECT id FROM assets WHERE id IN ({0})", ids); + string sql = string.Format("select UUID from assets where UUID in ({0})", ids); lock (this) { - using (SqliteCommand cmd = new SqliteCommand(SelectAssetSQL, m_conn)) + using (SqliteCommand cmd = new SqliteCommand(sql, m_conn)) { using (IDataReader reader = cmd.ExecuteReader()) { -- cgit v1.1