From 85e445c721f70dc17ea1eb2817e27b710f23b124 Mon Sep 17 00:00:00 2001 From: Minje Ahn Date: Wed, 30 Aug 2017 14:07:29 +0900 Subject: [PATCH] Update the query used to delete invalid items in storage Change-Id: I6a6e63c61474f3135b0267fde2524fed4cdbe843 Signed-off-by: Minje Ahn --- src/common/media-svc-media.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/common/media-svc-media.c b/src/common/media-svc-media.c index 217a5be..1892d21 100755 --- a/src/common/media-svc-media.c +++ b/src/common/media-svc-media.c @@ -524,7 +524,7 @@ int _media_svc_delete_invalid_items(sqlite3 *handle, const char *storage_id, med } } - char *sql = sqlite3_mprintf("DELETE FROM '%s' WHERE validity = 0;", storage_id); + char *sql = sqlite3_mprintf("DELETE FROM '%s' WHERE validity = 0 AND storage_type = %d;", storage_id, storage_type); ret = _media_svc_sql_query(sql, uid); SQLITE3_SAFE_FREE(sql); -- 2.7.4