[Spce-user] Billing with prefix not working
rkrenn at sipwise.com
Fri May 3 09:26:42 EDT 2019
Fixed quite some time ago https://github.com/sipwise/rate-o-mat/issues/1 . Not backported so upgrading to a newer version will do the trick.
Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Henk
Gesendet: Freitag, 3. Mai 2019 15:11
An: spce-user at lists.sipwise.com
Betreff: [Spce-user] Billing with prefix not working
Hi, I'm on mr6.5.3 and I uploaded billing fees in prefix form, after that rate-o-mat stops with "INFO: Caught DBI:err 1690" and
"DBD::mysql::st execute failed: BIGINT UNSIGNED value is out of range in '(_i at 8 - 1)' at /usr/sbin/rate-o-mat line 1590.
May 3 12:33:40 spce (info) rate-o-mat: FATAL: FATAL: Error executing profile info statement: BIGINT UNSIGNED value is out of range in '(_i at 8 - 1)'"
This error seems to be produced by function getbilling_fee_id. If I call it with the same parameters directly I get the same error:
MariaDB [billing]> select get_billing_fee_id(6,'call','out','31490000000 at 18.104.22.168 <mailto:31490000000 at 22.214.171.124> ','31880000000 at 126.96.36.199 <mailto:31880000000 at 188.8.131.52> ',NULL);
ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in '(_i at 8 - 1)'
The fees in profile 6 look correct. Will it help to upgrade to mr6.5.4?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Spce-user