Hi All,
I'm getting a strange warning message when I perform a MYSQL data lookup. The
operation performs fine, I retrive the data I'm looking for and continue on
through the dial sequence without an issue. I'm wondering if this warning
message is something to be concerned about, can't find any info about it.
warning message:
Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
Should I be concerned? Does anyone know what it means?
Thanks.
JR
I'm dialing extension 1001
extensions.conf
[lookupmysql]
exten => _X.,1,MYSQL(Connect connid 10.10.10.110 asteriskdb password table)
exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\ fullcontact\ from\
table_sip\ where\ name=${EXTEN})
exten => _X.,3,MYSQL(Fetch fetchid ${resultid} var1)
exten => _X.,4,MYSQL(Clear ${resultid})
exten => _X.,5,MYSQL(Disconnect ${connid})
exten => _X.,6,GotoIf($["${var1}" = ""]?invalid,i,1:${EXTEN},7)
exten => _X.,7,ChanIsAvail(SIP/${EXTEN}&IAX2/${EXTEN}|sj)
exten => _X.,8,Set(direct=${var1:4})
exten => _X.,9,Dial(SIP/${direct},30,r)
exten => _X.,10,Hangup
exten => _X.,108,Goto(sendtovm,${EXTEN},1)
exten => _X.,109,Hangup
asterisk-cli>
-- Goto (lookupmysql,1001,1)
-- Executing MYSQL("SIP/1239-fc6c", "Connect connid 10.10.10.110 asteriskdb
password table") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Query resultid 1 SELECT fullcontact
from complete_sip where name=1001") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Fetch fetchid 2 var1") in new stack
Mar 28 15:55:40 WARNING[27481]: app_addon_sql_mysql.c:318 aMYSQL_fetch:
ast_MYSQL_fetch: numFields=1
-- Executing MYSQL("SIP/1239-fc6c", "Clear 2") in new stack
-- Executing MYSQL("SIP/1239-fc6c", "Disconnect 1") in new stack
-- Executing GotoIf("SIP/1239-fc6c", "0?invalid|i|1:1001|7") in new stack
-- Goto (lookupmysql,1001,7)
-- Executing ChanIsAvail("SIP/1239-fc6c", "SIP/1001&IAX2/1001|sj") in new
stack
-- Executing Goto("SIP/1239-fc6c", "sendtovm|1001|1") in new stack
-- Goto (sendtovm,1001,1)
JR Richardson
Engineering for the Masses
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
