Re: [asterisk-users] app_addon_sql_mysql.c:116 find_identifier

2010-05-14 Thread Doug Lytle
Jonas Kellens wrote: > It does not make a difference because it is the same result : All the > other queries go well, just the last one gives this 'WARNING'. > You may want to give func_odbc a try, several say it's a better way: http://www.voip-info.org/wiki/index.php?page=Asterisk+func+func_odb

Re: [asterisk-users] app_addon_sql_mysql.c:116 find_identifier

2010-05-14 Thread Jonas Kellens
It does not make a difference because it is the same result : All the other queries go well, just the last one gives this 'WARNING'. Using 1.4.25.1 Jonas. On 05/14/2010 11:46 AM, Doug Lytle wrote: Jonas Kellens wrote: But it does not make a difference... I'm running Asterisk 1.4

Re: [asterisk-users] app_addon_sql_mysql.c:116 find_identifier

2010-05-14 Thread Doug Lytle
Jonas Kellens wrote: > > > But it does not make a difference... I'm running Asterisk 1.4.x, what version are you running? Doug -- Ben Franklin quote: "Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety." --

Re: [asterisk-users] app_addon_sql_mysql.c:116 find_identifier

2010-05-14 Thread Jonas Kellens
The voip-info.org tells it differently : *MYSQL(Clear* ${resultid}*)* Frees memory and data structures associated with result set. *MYSQL(Disconnect* ${connid}*)* Disconnects from named connection to MySQL. But it does not make a difference... It's strange that every mysql-query is the same

Re: [asterisk-users] app_addon_sql_mysql.c:116 find_identifier

2010-05-13 Thread Doug Lytle
Jonas Kellens wrote: > exten => s,n,NoOp(fetchid = ${fetchid}) > exten => s,n,MYSQL(Clear ${resultid}) > exten => s,n,MYSQL(Disconnect ${connid}) The only different between yours and mine is that I do a disconnect before I do the clear. Try: exten => s,n,MYSQL(Fetch fetchid ${resultid} extensie

[asterisk-users] app_addon_sql_mysql.c:116 find_identifier

2010-05-13 Thread Jonas Kellens
Hello list, I have the following problem with MySQL-queries : it seems that the resultid and connid are not cleared ! [macro-GetMailboxFromSIPuserID] exten => s,1,MYSQL(Connect connid localhost xxx xxx xxx) exten => s,n,MYSQL(Query resultid ${connid} SELECT\ extensie FROM\ tbl_SIPaccounts\ WH