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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JR Richardson Sent: Tuesday, March 28, 2006 4:22 PM To: asterisk-users@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 _______________________________________________ --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
