[OpenSER-Users] MySQL Error message

[Daniel-Constantin Mierla]

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