From 03da48757a783f54071a4ae93ae53cf56a9ebd86 Mon Sep 17 00:00:00 2001 From: Kyeonghun Lee Date: Fri, 28 Oct 2016 13:21:57 +0900 Subject: [PATCH] [TSAM-9200] fix query error Change-Id: I51b9a9f9e26403197ef65afa88c2127d08ebb773 Signed-off-by: Kyeonghun Lee --- manager/src/msg-manager-notification.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/manager/src/msg-manager-notification.cpp b/manager/src/msg-manager-notification.cpp index d977352..533ba53 100644 --- a/manager/src/msg-manager-notification.cpp +++ b/manager/src/msg-manager-notification.cpp @@ -1787,7 +1787,7 @@ int getLatestMsgInfo(MSG_MGR_NOTI_INFO_S *noti_info, bool isForInstantMessage) "B.ATTACHMENT_COUNT " "FROM %s B " "LEFT JOIN %s A ON A.CONV_ID=B.CONV_ID " - "AND B.READ_STATUS=0 AND (B.FOLDER_ID=%d OR B.FOLDER_ID=%d) " + "WHERE B.READ_STATUS=0 AND (B.FOLDER_ID=%d OR B.FOLDER_ID=%d) " "AND B.STORAGE_ID = %d " "ORDER BY B.DISPLAY_TIME DESC;", MSG_MMS_TYPE, MSG_NETWORK_RECEIVED, MMS_PLUGIN_MESSAGE_TABLE_NAME, -- 2.7.4