7 Jul
2008
7 Jul
'08
10:42 a.m.
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