Displaying 1 result from an estimated 1 matches for "b7bbfaf0".
Did you mean:
7bbf9af0
2007 Apr 19
1
MySQL Update from exten
...rrentcalls=currentcalls+1\
WHERE\ dnis=\'${IVR-Exten}\'\ AND\ ani=\'${CALLERID(number)}\')
exten => update,n,MYSQL(Clear ${resultid})
exten => update,n,MYSQL(Disconnect ${connid})
Asterisk logs says:
Apr 19 15:50:05 VERBOSE[19740] logger.c: -- Executing
MYSQL("SIP/5400-b7bbfaf0", "QUERY resultid 201 UPDATE caller SET
lastcall= 04/18/07 11:12:55, totalcalls= totalcalls+1, currentcalls=
currentcalls+1 WHERE dnis= '7690' AND ani= '5400'") in new stack
Apr 19 15:50:05 WARNING[18333] app_addon_sql_mysql.c: Identifier 200,
identifier_type 2 not...