--- a/engine/src/ShowEngine.cpp	Fri Nov 19 01:47:31 2010 +0000
+++ b/engine/src/ShowEngine.cpp	Sun Nov 21 20:11:07 2010 +0000
@@ -575,6 +575,23 @@
 		{
 		User::Leave(KErrCorrupt);
 		}
+	
+	// now update DB
+	_LIT(KSqlStatement2, "update shows set downloadstate=%d and deletedate = 0 where downloadstate=%d and deletedate != 0 and deletedate < \"%Ld\"");
+	iSqlBuffer.Format(KSqlStatement2, ENotDownloaded, EDownloaded, now.Int64());
+
+
+	rc = sqlite3_prepare16_v2(&iDB, (const void*) iSqlBuffer.PtrZ(), -1,
+			&st, (const void**) NULL);
+
+	if (rc == SQLITE_OK)
+		{
+		rc = sqlite3_step(st);
+		Cleanup_sqlite3_finalize_PushL(st);
+		CleanupStack::PopAndDestroy();//st
+		}
+
+	
 	DP("CShowEngine::DBGetOldShowsL END");
 	}