<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif"><big>The voip-info.org tells
it
differently :</big><br>
<br>
</font><strong>MYSQL(Clear</strong> ${resultid}<strong>)</strong>
<br>
<br>
Frees memory and data structures associated with result set.
<br>
<br>
<strong>MYSQL(Disconnect</strong> ${connid}<strong>)</strong>
<br>
<br>
Disconnects from named connection to MySQL.<br>
<br>
<big>But it does not make a difference...<br>
<br>
It's strange that every mysql-query is the same :</big><br>
<br>
<br>
[May 14 09:20:24] -- Executing [s@macro-QueryAstDB:5]
MYSQL("Local/20@105002-ca25,2", "Clear 20") in new stack<br>
[May 14 09:20:24] -- Executing [s@macro-QueryAstDB:6]
MYSQL("Local/20@105002-ca25,2", "Disconnect 19") in new stack<br>
<br>
[May 14 09:20:24] -- Executing [s@macro-GetSIPaccount:5]
MYSQL("Local/20@105002-ca25,2", "Clear 20") in new stack<br>
[May 14 09:20:24] -- Executing [s@macro-GetSIPaccount:6]
MYSQL("Local/20@105002-ca25,2", "Disconnect 19") in new stack<br>
<br>
[May 14 09:20:34] -- Executing [s@macro-GetMailboxFromSIPuserID:5]
MYSQL("SIP/testcorp-083a2128", "Disconnect 19") in new stack<br>
[May 14 09:20:34] -- Executing [s@macro-GetMailboxFromSIPuserID:6]
MYSQL("SIP/testcorp-083a2128", "Clear 20") in new stack<br>
<br>
<big>And then the last MySql-query :</big><br>
<br>
[May 14 09:20:40] -- Executing [s@macro-SDgeenopname:5]
MYSQL("SIP/testcorp-083a2128", "Clear 20") in new stack<br>
[May 14 09:20:40] WARNING[5939]: app_addon_sql_mysql.c:116
find_identifier: Identifier 20, identifier_type 2 not found in
identifier list<br>
[May 14 09:20:40] WARNING[5939]: app_addon_sql_mysql.c:355
aMYSQL_clear: Invalid result identifier 20 passed in aMYSQL_clear<br>
[May 14 09:20:40] -- Executing [s@macro-SDgeenopname:6]
MYSQL("SIP/testcorp-083a2128", "Disconnect 19") in new stack<br>
<br>
<br>
<big>The only difference is that this is a macro which is executed in
the h-extension (so after the channel has been hung up). Could this be
the issue ??<br>
If so, what is the solution ?? No real solution is needed as it does
not mess up anything, but it still is a "WARNING".</big><br>
<br>
<br>
<br>
<font face="Helvetica, Arial, sans-serif"><big>Jonas.</big><br>
</font><br>
On 05/13/2010 04:26 PM, Doug Lytle wrote:
<blockquote cite="mid:4BEC0C31.6020100@drdos.info" type="cite">
<pre wrap="">Jonas Kellens wrote:
</pre>
<blockquote type="cite">
<pre wrap="">exten => s,n,NoOp(fetchid = ${fetchid})
exten => s,n,MYSQL(Clear ${resultid})
exten => s,n,MYSQL(Disconnect ${connid})
</pre>
</blockquote>
<pre wrap="">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</pre>
</blockquote>
<br>
</body>
</html>