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

[Tim Connolly]

I've been seeing this for a while. No clue how to fix. The source I have
from my last update says extra_log=0, so it "shouldn't" be showing this
message at all... 


-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of JR
Richardson
Sent: Tuesday, March 28, 2006 4:22 PM
To: asterisk-users at lists.digium.com
Subject: [Asterisk-Users] Asterisk to MySQL Data Lookup Warning Message?

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