[asterisk-users] MySQL Error Message

Barton Fisher bart at icpage.com
Mon Dec 1 15:20:46 CST 2008


Can some tell me what this warnings means? 
The dialplan works, but I get these warnings every once in a while:

Log:

[Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Identifier 0, identifier_type 2 not found in identifier list
[Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Invalid result identifier 0 passed in aMYSQL_clear
[Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Identifier 4, identifier_type 2 not found in identifier list
[Dec 1 12:26:31] WARNING[20425] app_addon_sql_mysql.c: Invalid result identifier 4 passed in aMYSQL_clear

DialPlan:

 exten => s,1,Noop()
 exten => s,n,MYSQL(Connect connid localhost userid password database)
 exten => s,n,MYSQL(Query resultid ${connid} SELECT\ name\ FROM\ cnam\ WHERE\ ani=\'${CALLERID(number)}\')
 exten => s,n,MYSQL(Fetch fetchid ${resultid} name)
 exten => s,n,MYSQL(Clear ${resultid})
 exten => s,n,MYSQL(Disconnect ${connid})

Thanks, Bart
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20081201/0351ae6c/attachment.htm 


More information about the asterisk-users mailing list