<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif"><big>Hello list,<br>
<br>
I have the following problem with MySQL-queries : it seems that the
resultid and connid are not cleared !</big><br>
<br>
[macro-GetMailboxFromSIPuserID]<br>
exten => s,1,MYSQL(Connect connid localhost xxx xxx xxx)<br>
exten => s,n,MYSQL(Query resultid ${connid} SELECT\ extensie FROM\
tbl_SIPaccounts\ WHERE\ ID="${ARG1}")<br>
exten => s,n,MYSQL(Fetch fetchid ${resultid} extensie)<br>
exten => s,n,NoOp(fetchid = ${fetchid})<br>
exten => s,n,MYSQL(Clear ${resultid})<br>
exten => s,n,MYSQL(Disconnect ${connid})<br>
exten => s,n,MacroExit()<br>
<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:1]
MYSQL("SIP/testcorp-0827e670", "Connect connid localhost xxx xxx xxx")
in new stack<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:2]
MYSQL("SIP/testcorp-0827e670", "Query resultid 19 SELECT extensie FROM
tbl_SIPaccounts WHERE ID="105002"") in new stack<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:3]
MYSQL("SIP/testcorp-0827e670", "Fetch fetchid 20 extensie") in new stack<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:4]
NoOp("SIP/testcorp-0827e670", "fetchid = 0") in new stack<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:5]
MYSQL("SIP/testcorp-0827e670", "<b><font color="#33cc00">Clear 20</font></b>")
in new stack<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:6]
MYSQL("SIP/testcorp-0827e670", "<b><font color="#33cc00">Disconnect 19</font></b>")
in new stack<br>
[May 13 16:00:34] -- Executing [s@macro-GetMailboxFromSIPuserID:7]
MacroExit("SIP/testcorp-0827e670", "") in new stack<br>
<br>
<br>
[macro-SDgeenopname])<br>
exten => s,1,MYSQL(Connect connid5 localhost xxx xxx xxx)<br>
exten => s,n,MYSQL(Query resultid5 ${connid5} DELETE\ FROM\
recordings\ WHERE\ file="${xxx}")<br>
exten => s,n,MYSQL(Clear ${resultid5})<br>
exten => s,n,MYSQL(Disconnect ${connid5})<br>
<br>
[May 13 16:00:39] -- Executing [s@macro-SDgeenopname:3]
MYSQL("SIP/testcorp-0827e670", "Connect connid localhost xxx xxx xxx")
in new stack<br>
[May 13 16:00:39] -- Executing [s@macro-SDgeenopname:4]
MYSQL("SIP/testcorp-0827e670", "Query resultid 19 DELETE FROM
recordings WHERE file="xxx"") in new stack<br>
[May 13 16:00:39] -- Executing [s@macro-SDgeenopname:5]
MYSQL("SIP/testcorp-0827e670", "<b><font color="#33cc00">Clear 20</font></b>")
in new stack<br>
<font color="#ff0000">[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<br>
[May 13 16:00:39] WARNING[4358]: app_addon_sql_mysql.c:355
aMYSQL_clear: Invalid result identifier 20 passed in aMYSQL_clear</font><br>
[May 13 16:00:39] -- Executing [s@macro-SDgeenopname:6]
MYSQL("SIP/testcorp-0827e670", "<font color="#33cc00"><b>Disconnect 19</b></font>")
in new stack<br>
<br>
<br>
<big>With every call it's the same... something with this '19' and
'20'...<br>
<br>
<br>
Jonas.</big><br>
</font>
</body>
</html>