From 785f3884f4edb713be7a60c94782eddde7ffbe8d Mon Sep 17 00:00:00 2001 From: Jeesun Kim Date: Mon, 2 Jan 2017 15:41:39 +0900 Subject: [PATCH] fix invalid query - need space betweeen parameter and table name Change-Id: Ice7cd47ed9f216d272136ff1ff8423f065e54bcb --- server/ctsvc_server_person.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/server/ctsvc_server_person.c b/server/ctsvc_server_person.c index 1bf883d..d9d8427 100644 --- a/server/ctsvc_server_person.c +++ b/server/ctsvc_server_person.c @@ -747,7 +747,7 @@ int ctsvc_person_aggregate(int person_id) /* check vibration */ if (person->vibration) { snprintf(query, sizeof(query), - "SELECT C.contact_idFROM "CTS_TABLE_CONTACTS" C " + "SELECT C.contact_id FROM "CTS_TABLE_CONTACTS" C " "WHERE C.person_id=%d AND C.deleted = 0 " "AND C.vibration = '%s'", person->person_id, person->vibration); @@ -758,7 +758,7 @@ int ctsvc_person_aggregate(int person_id) vibration = NULL; } - /* check vibration */ + /* check message_alert */ if (person->message_alert) { snprintf(query, sizeof(query), "SELECT C.contact_id FROM "CTS_TABLE_CONTACTS" C " -- 2.7.4