Hi Jayesh,
The first thing that comes to mind is that you can cast your floats to
string directly from the mysql query ( with something like
cast(your_field as char) ).
Could you please send us an example of the avp_db_query that was
previously working, along with the 'show create table' for the table you
are querying ?
Feel free to change whatever relevant columns names, I just want to
replicate this issue on my own machine :)
Best Regards,
Vlad Paiu
OpenSIPS Developer
http://www.opensips-solutions.com
On 03/13/2013 04:56 AM, Ovidiu Sas wrote:
Make sure that the values are stored as strings in the table, not as float.
-ovidiu
On Tue, Mar 12, 2013 at 10:40 PM, Jayesh Nambiar<[email protected]> wrote:
Hi Ovidiu,
Thanks for your reply. But I just expect them to be stored as string in my
AVPs. Even in 1.8.2, when I dumped those AVPs back into a database table, it
always put the exact value like 1.0000 or 0.0123 etc. So it was indeed
storing the entire value as string in the AVPs and not as 1 or 0. Is this
behaviour changed now?
--- Jayesh
On Tuesday, March 12, 2013, Ovidiu Sas wrote:
You are trying to store a float into an int. Prior to 1.9, there
wasn't a strict check on the conversion and whatever the result was,
it was stored (i.e. 1.000 was stored as 1 and 0.0123 was stored as 0).
For more info: http://linux.die.net/man/3/strtol
Starting with 1.9, there is a strict check for invalid characters and
therefore the conversion fails: 1.000 and 0.0123 are not a valid
integers.
Regards,
Ovidiu Sas
On Tue, Mar 12, 2013 at 10:36 AM, Jayesh Nambiar<[email protected]>
wrote:
Hi,
I am testing out Opensips-1.9 currently. While I was using
opensips-1.8.2, I
used avp_db_query to query some values from database tables which were
float
point values and used those values to insert into acc table. Obviously
for
billing reasons. But after upgrading to 1.9 it gives error.
Eg: I am querying a table containing values 1.0000, 0.0123 etc. and
storing
it into AVPs. But the 1.9 version gives the following error:
ERROR:core:db_str2int: Unexpected characters: [.0000]
ERROR:db_mysql:db_mysql_str2val: error while converting integer value
from
string
Can someone help me to take corrective actions inorder to avoid these
errors. Any help is much appreciated.
Thanks,
--- Jayesh
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
