13 Sep
2006
13 Sep
'06
3:46 p.m.
Hi!
I try to make the following query but it doesn't work...
avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
As the Mysql server can do the query, I suppose that I made a syntax
error in the openser.cfg.
Does somebody know what is wrong?
Thanks,
Michel
13 Sep
13 Sep
6:37 p.m.
Hello,
do you get any error in the log? Did you try to print $avp(i:50) just
after the avp_db_query()?
Cheers,
Daniel
On 09/13/06 16:46, Michel Zenone wrote:
Hi!
I try to make the following query but it doesn't work...
avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
As the Mysql server can do the query, I suppose that I made a syntax
error in the openser.cfg.
Does somebody know what is wrong?
Thanks,
Michel
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
14 Sep
14 Sep
10:20 a.m.
Hi!
In the log it can be read:
Sep 13 18:11:51 localhost /usr/local/sbin/openser[5661]: db_raw_query:
Error while submitting query
Sep 13 18:11:51 localhost /usr/local/sbin/openser[5661]:
avpops:db_query_avp: error - cannot do the query
Then, $avp(i:30) has a right value but $avp(i:50) seems to have no
value: <null>.
Regards,
Michel
On Wed, 2006-09-13 at 19:37 +0300, Daniel-Constantin Mierla wrote:
Hello,
do you get any error in the log? Did you try to print $avp(i:50) just
after the avp_db_query()?
Cheers,
Daniel
On 09/13/06 16:46, Michel Zenone wrote:
Hi!
I try to make the following query but it doesn't work...
avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
As the Mysql server can do the query, I suppose that I made a syntax
error in the openser.cfg.
Does somebody know what is wrong?
Thanks,
Michel
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users
12:08 p.m.
On 09/14/06 11:20, Michel Zenone wrote:
Hi!
In the log it can be read:
Sep 13 18:11:51 localhost /usr/local/sbin/openser[5661]: db_raw_query:
Error while submitting query
Sep 13 18:11:51 localhost /usr/local/sbin/openser[5661]:
avpops:db_query_avp: error - cannot do the query
Then, $avp(i:30) has a right value but $avp(i:50) seems to have no
value: <null>.
that's very odd, I tested by myself and got :
0(5425) avpops:ops_dbquery_avps: query [select round(320/100)]
0(5425) SCRIPT: avp(i:30)=320 avp(i:50)=3
The config snippet I used is:
avp_write("i:320", "$avp(i:30)");
avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
xlog("SCRIPT: avp(i:30)=$avp(i:30) avp(i:50)=$avp(i:50)\n");
Please run openser in higher debug level: debug=7 for example.
Cheers,
Daniel
Regards,
Michel
On Wed, 2006-09-13 at 19:37 +0300, Daniel-Constantin Mierla wrote:
Hello,
do you get any error in the log? Did you try to print $avp(i:50) just
after the avp_db_query()?
Cheers,
Daniel
On 09/13/06 16:46, Michel Zenone wrote:
> Hi!
> I try to make the following query but it doesn't work...
>
> avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
>
> As the Mysql server can do the query, I suppose that I made a syntax
> error in the openser.cfg.
>
> Does somebody know what is wrong?
>
> Thanks,
>
> Michel
>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>
>
6720
days inactive
6721
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Michel Zenone