Thanks Daniel, I resolved the problem. It's not a problem whith openser but with my syntax<br><br>Regards<br>Yazid<br><br><div class="gmail_quote">On Mon, Jul 7, 2008 at 9:42 AM, Daniel-Constantin Mierla <<a href="mailto:miconda@gmail.com">miconda@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello<div><div></div><div class="Wj3C7c"><br>
<br>
On 07/07/08 10:33, Yazid Hadj Said wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
I work with 1.3.1 version and when I perform MySQL Instructions with avp_db_query, I have this error mesage:<br>
<br>
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<br>
Jul 7 09:20:36 [19247] ERROR:mysql:db_mysql_raw_query: error while submitting query<br>
Jul 7 09:20:36 [19247] ERROR:avpops:db_query_avp: cannot do the query<br>
<br>
But I have not mistake in my SQL syntax,<br>
<br>
Is It a bug?<br>
</blockquote></div></div>
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.<br>
<br>
Cheers,<br>
Daniel<br><font color="#888888">
<br>
-- <br>
Daniel-Constantin Mierla<br>
<a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a><br>
<br>
</font></blockquote></div><br>