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 [...@macro-getmailboxfromsipuserid:1]
MYSQL("SIP/testcorp-0827e670", "Connect connid localhost xxx xxx xxx")
in new stack
[May 13 16:00:34] -- Executing [...@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 [...@macro-getmailboxfromsipuserid:3]
MYSQL("SIP/testcorp-0827e670", "Fetch fetchid 20 extensie") in new stack
[May 13 16:00:34] -- Executing [...@macro-getmailboxfromsipuserid:4]
NoOp("SIP/testcorp-0827e670", "fetchid = 0") in new stack
[May 13 16:00:34] -- Executing [...@macro-getmailboxfromsipuserid:5]
MYSQL("SIP/testcorp-0827e670", "*Clear 20*") in new stack
[May 13 16:00:34] -- Executing [...@macro-getmailboxfromsipuserid:6]
MYSQL("SIP/testcorp-0827e670", "*Disconnect 19*") in new stack
[May 13 16:00:34] -- Executing [...@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 [...@macro-sdgeenopname:3]
MYSQL("SIP/testcorp-0827e670", "Connect connid localhost xxx xxx xxx")
in new stack
[May 13 16:00:39] -- Executing [...@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 [...@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 [...@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.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users