Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.0.7
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Windows 32bit
-
Platform:Win32/VS
-
CPU Info:
-
GCC Version:VS2008
-
FreeSWITCH GIT Revision:GIT HEAD 4/26/11 15:10:37
-
Reproduced with GIT HEAD?:Yes
-
Target Version:
Description
Receive the following continuous repeating error when loading mod_callcenter
2011-04-26 20:12:32.072813 [ERR] switch_core_sqldb.c:833 SQL ERR: [SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(] near "(": syntax error
It looks like its coming from mod_callcenter.c line 2153
while (globals.running == 1) {
char *sql = NULL;
sql = switch_mprintf("SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(%" SWITCH_TIME_T_FMT "-joined_epoch)+base_score+skill_score AS score, state, abandoned_epoch FROM members"
" WHERE state = '%q' OR state = '%q' OR (serving_agent = 'ring-all' AND state = '%q') ORDER BY score DESC",
local_epoch_time_now(NULL),
cc_member_state2str(CC_MEMBER_STATE_WAITING), cc_member_state2str(CC_MEMBER_STATE_ABANDONED), cc_member_state2str(CC_MEMBER_STATE_TRYING));
cc_execute_sql_callback(NULL /* queue */, NULL /* mutex */, sql, members_callback, NULL /* Call back variables */);
switch_safe_free(sql);
switch_yield(100000);
}
2011-04-26 20:12:32.072813 [ERR] switch_core_sqldb.c:833 SQL ERR: [SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(] near "(": syntax error
It looks like its coming from mod_callcenter.c line 2153
while (globals.running == 1) {
char *sql = NULL;
sql = switch_mprintf("SELECT queue,uuid,session_uuid,cid_number,cid_name,joined_epoch,(%" SWITCH_TIME_T_FMT "-joined_epoch)+base_score+skill_score AS score, state, abandoned_epoch FROM members"
" WHERE state = '%q' OR state = '%q' OR (serving_agent = 'ring-all' AND state = '%q') ORDER BY score DESC",
local_epoch_time_now(NULL),
cc_member_state2str(CC_MEMBER_STATE_WAITING), cc_member_state2str(CC_MEMBER_STATE_ABANDONED), cc_member_state2str(CC_MEMBER_STATE_TRYING));
cc_execute_sql_callback(NULL /* queue */, NULL /* mutex */, sql, members_callback, NULL /* Call back variables */);
switch_safe_free(sql);
switch_yield(100000);
}