[asterisk-users] MySQL Error Message

[Barton Fisher]

> Barton Fisher wrote:
>> Can some tell me what this warnings means?
>> The dialplan works, but I get these warnings every once in a while:
>>
>
> I'm guessing that some times the caller-id is blank.  I got tired of
> those errors and did the following before the query:
>
> exten => s,1,GotoIf($["${CALLERID(num)}" = "" ]?2:3)
> exten => s,n,Set(CALLERID(all)=Restricted <0>)
> exten => s,1,Noop()
> exten => s,n,MYSQL(Connect connid localhost userid password database)
>
>
> Doug
>

Sorry, I removed those lines before I posted dialplan - I do check to see if 
there is some value before I write
Here's another case:

[Dec 1 13:48:15] WARNING[14017] app_addon_sql_mysql.c: Identifier 0, 
identifier_type 2 not found in identifier list
[Dec 1 13:48:15] WARNING[14017] app_addon_sql_mysql.c: Invalid result 
identifier 0 passed in aMYSQL_clear
[Dec 1 13:48:15] VERBOSE[14017] logger.c: [5412254900-inn] [8006848429] 
[update-cnam] NAME Updated=[8006848429 800 Service ]
[Dec 1 13:48:15] WARNING[14017] app_addon_sql_mysql.c: Identifier 4, 
identifier_type 2 not found in identifier list
[Dec 1 13:48:15] WARNING[14017] app_addon_sql_mysql.c: Invalid result 
identifier 4 passed in aMYSQL_clear
[Dec 1 13:48:15] VERBOSE[14017] logger.c: [5412254900-inn] [8006848429] 
Database Marketing [5412254900] [8006848429] [800 Service ]

any ideas?

Bart