[asterisk-users] Problem with MYSQL commands in dialplan

[Mike]

Hi,
 
I have been using MYSQL successfully from the dialplan in the past, but I am
stumped this morning trying to use it for some other table.  I am basically
cut and pasting from the wiki.  Here is my CLI output: 
 
    -- Executing NoOp("SIP/11.11.11.11", "701") in new stack
    -- Executing MYSQL("SIP/11.11.11.11", "Connect connid localhost username
password database_name") in new stack      ---(same input works at other
places)
    -- Executing MYSQL("SIP/11.11.11.11", "Query resultid 1 SELECT
redirection_data from redirections where accountcode=5145555555 and
exten=701 and active=true") in new stack
  -- Executing MYSQL("SIP/11.11.11.11", "Fetch fetchid 2 redirection_data")
in new stack
Nov  2 12:51:30 WARNING[24892]: app_addon_sql_mysql.c:115 find_identifier:
Identifier 2, identifier_type 2 not found in identifier list
Nov  2 12:51:30 WARNING[24892]: app_addon_sql_mysql.c:330 aMYSQL_fetch:
aMYSQL_fetch: Invalid result identifier 2 passed
    -- Executing MYSQL("SIP/11.11.11.11", "Clear 2") in new stack
Nov  2 12:33:44 WARNING[24450]: app_addon_sql_mysql.c:115 find_identifier:
Identifier 2, identifier_type 2 not found in identifier list
Nov  2 12:33:44 WARNING[24450]: app_addon_sql_mysql.c:348 aMYSQL_clear:
Invalid result identifier 2 passed in aMYSQL_clear
    -- Executing MYSQL("SIP/11.11.11.11", "Disconnect 1") in new stack
    -- Executing NoOp("SIP/11.11.11.11", "") in new stack
 
I am running 1.2.4.  Not even sure what the warning means (WARNING[24892]:
app_addon_sql_mysql.c:115 find_identifier: Identifier 2, identifier_type 2
not found in identifier list).  
 
 
Any help is appreciated.
 
Mike

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20061102/0e7f2475/attachment.htm