[OpenSER-Users] MySQL Error message

[Yazid Hadj Said]

Thanks Daniel,  I resolved the problem. It's not a problem whith openser but
with my syntax

Regards
Yazid

On Mon, Jul 7, 2008 at 9:42 AM, Daniel-Constantin Mierla <miconda at gmail.com>
wrote:

> Hello
>
>
> On 07/07/08 10:33, Yazid Hadj Said wrote:
>
>> Hi,
>> I work with 1.3.1 version and when I perform MySQL Instructions with
>> avp_db_query, I have this error mesage:
>>
>> Jul  7 09:20:36 [19247] ERROR:mysql:db_mysql_submit_query: driver error:
>> You have an error in your SQL syntax; check the manual that corresponds to
>> your MySQL server version for the right syntax to use near 'condition  from
>>  rules' at line 1
>> Jul  7 09:20:36 [19247] ERROR:mysql:db_mysql_raw_query: error while
>> submitting query
>> Jul  7 09:20:36 [19247] ERROR:avpops:db_query_avp: cannot do the query
>>
>> But I have not mistake in my SQL syntax,
>>
>> Is It a bug?
>>
> there seem to be a mistake in the sql, maybe after expanding
> pseudo-variables in the parameter of avp_db_query. What the sql query log of
> mysql or start openser in debug mode, should print the query in the log
> messages -- see if the query sent to mysql is ok.
>
> Cheers,
> Daniel
>
> --
> Daniel-Constantin Mierla
> http://www.asipto.com
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080707/569ed634/attachment.htm