7 Jul
2008
7 Jul
'08
10:33 a.m.
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?
Regards
Yazid
7 Jul
7 Jul
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
12:05 p.m.
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(a)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
6012
days inactive
6012
days old
2 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Yazid Hadj Said