[asterisk-users] app_addon_sql_mysql.c:116 find_identifier

[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\ 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