asterisk users - May 2010 - app_addon_sql_mysql.c:116 find_identifier

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\ WHERE\ ID="${ARG1}")
exten => s,n,MYSQL(Fetch fetchid ${resultid} extensie)
exten => s,n,NoOp(fetchid = ${fetchid})
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,MacroExit()

[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:1] 
MYSQL("SIP/testcorp-0827e670", "Connect connid localhost xxx xxx
xxx")
in new stack
[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:2] 
MYSQL("SIP/testcorp-0827e670", "Query resultid 19 SELECT extensie
FROM
tbl_SIPaccounts WHERE ID="105002"") in new stack
[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:3] 
MYSQL("SIP/testcorp-0827e670", "Fetch fetchid 20 extensie")
in new stack
[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:4] 
NoOp("SIP/testcorp-0827e670", "fetchid = 0") in new stack
[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:5] 
MYSQL("SIP/testcorp-0827e670", "*Clear 20*") in new stack
[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:6] 
MYSQL("SIP/testcorp-0827e670", "*Disconnect 19*") in new
stack
[May 13 16:00:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:7] 
MacroExit("SIP/testcorp-0827e670", "") in new stack


[macro-SDgeenopname])
exten => s,1,MYSQL(Connect connid5 localhost xxx xxx xxx)
exten => s,n,MYSQL(Query resultid5 ${connid5} DELETE\ FROM\ recordings\ 
WHERE\ file="${xxx}")
exten => s,n,MYSQL(Clear ${resultid5})
exten => s,n,MYSQL(Disconnect ${connid5})

[May 13 16:00:39]     -- Executing [s at macro-SDgeenopname:3] 
MYSQL("SIP/testcorp-0827e670", "Connect connid localhost xxx xxx
xxx")
in new stack
[May 13 16:00:39]     -- Executing [s at macro-SDgeenopname:4] 
MYSQL("SIP/testcorp-0827e670", "Query resultid 19 DELETE FROM
recordings
WHERE file="xxx"") in new stack
[May 13 16:00:39]     -- Executing [s at macro-SDgeenopname:5] 
MYSQL("SIP/testcorp-0827e670", "*Clear 20*") in new stack
[May 13 16:00:39] WARNING[4358]: app_addon_sql_mysql.c:116 
find_identifier: Identifier 20, identifier_type 2 not found in 
identifier list
[May 13 16:00:39] WARNING[4358]: app_addon_sql_mysql.c:355 aMYSQL_clear: 
Invalid result identifier 20 passed in aMYSQL_clear
[May 13 16:00:39]     -- Executing [s at macro-SDgeenopname:6] 
MYSQL("SIP/testcorp-0827e670", "*Disconnect 19*") in new
stack


With every call it's the same... something with this '19' and
'20'...


Jonas.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100513/ea16b64d/attachment.htm

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)
exten => s,n,NoOp(fetchid = ${fetchid})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,MYSQL(Clear ${resultid})


My guess is (If it works), that you can't clear an open channel.

Doug


-- 

Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."