[Asterisk-Users] Asterisk to MySQL Data Lookup Warning Message?

[JR Richardson]

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