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
