[Astpp-tracker] [ astpp-Bugs-1800039 ] Call rating issue
Brought to you by:
darrenkw
Menu
▾
▴
[Astpp-tracker] [ astpp-Bugs-1800039 ] Call rating issue
|
From: SourceForge.net <no...@so...> - 2007-11-18 02:30:03
|
Bugs item #1800039, was opened at 2007-09-21 19:27 Message generated for change (Comment added) made by darrenkw You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1800039&group_id=205663 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 8 Private: No Submitted By: Aleph Communications (darrenkw) Assigned to: Aleph Communications (darrenkw) Summary: Call rating issue Initial Comment: From: Cron Daemon <ro...@si...> Date: Sep 22, 2007 1:05 AM Subject: Cron <root@de> /opt/sipa2z/scripts/astpp-fix-rate.pl To: ro...@si... Interface language is set to: en Connected to ASTPP Database! DBI:mysql:database=asterisk;host= 127.0.0.1Connected to CDR Database! Processing Uniqueid: 1190402025.14279---------------------- uniqueid: 1190402025.14279, cardno: sarwar, phoneno: 00971508035911, Userfield: FORKED disposition: ANSWERED Pricelist: itcforwarding reseller: itc SELECT * FROM routes WHERE '00971508035911' RLIKE pattern AND pricelist = 'itcforwarding' ORDER BY LENGTH(pattern) DESC pattern: ^(011|00|^)97150.* Route: United Arab Emirates-Mobile Cost: 1600 Pricelist: itcforwarding Pattern: ^(011|00|^)97150.* PATTERN: ^(011|00|^)97150.*FOUND A MATCHING PATTERN. SELECT * FROM pricelists WHERE name = 'itcforwarding' pricelistData: itcforwarding 0 1 1 0, 1600, 272, 60, 0Connect: 0 Cost: 1600 Answered: 272 Inc: 60 included: 0 AnsweredTime: 272 Included Sec: 0 Increment: 60 Total Increments: 4.53333333333333 Bill Seconds: 300 Total cost is 8000 Matching pattern is ^(011|00|^)97150.* INSERT INTO cdrs(uniqueid,cardnum,callerid,callednum,trunk,disposition,billseconds,debit,callstart,status,notes) VALUES ('HASH(0x899b24c)', ' 1190402025.14279', 'sarwar', '0427419389', 'N/A', '00971508035911', 'ANSWERED', '272', '8000.00', '0', NULL) Reseller: itc Charge 1190402025.14279 to itc---------------------- uniqueid: 1190402025.14279, cardno: itc, phoneno: 00971508035911, Userfield: FORKED disposition: ANSWERED Pricelist: xeiva reseller: SELECT * FROM routes WHERE '00971508035911' RLIKE pattern AND pricelist = 'xeiva' ORDER BY LENGTH(pattern) DESC pattern: ^(011|00|^)97150.* Route: United Arab Emirates-Mobile Cost: 1550 Pricelist: xeiva Pattern: ^(011|00|^)97150.* PATTERN: ^(011|00|^)97150.*FOUND A MATCHING PATTERN. SELECT * FROM pricelists WHERE name = 'xeiva' pricelistData: xeiva 0 1 1 0, 1550, 272, 1, 0Connect: 0 Cost: 1550 Answered: 272 Inc: 1 included: 0 AnsweredTime: 272 Included Sec: 0 Increment: 1 Total Increments: 272 Bill Seconds: 272 Total cost is 7026.66666666667 Matching pattern is ^(011|00|^)97150.* INSERT INTO cdrs(uniqueid,cardnum,callerid,callednum,trunk,disposition,billseconds,debit,callstart,status,notes) VALUES ('HASH(0x899b24c)', '1190402025.14279 ', 'itc', '0427419389', 'N/A', '00971508035911', 'ANSWERED', '272', '7026.67', '0', NULL) Reseller: SELECT id FROM cdrs WHERE uniqueid = '1190402025.14279 ' AND cardnum = 'sarwar' LIMIT 1 SELECT id,debit,credit FROM cdrs WHERE uniqueid = '1190402025.14279' AND cardnum = 'itc' LIMIT 1 Use of uninitialized value in subtraction (-) at /usr/local/astpp/astpp- common.pl line 3865. Use of uninitialized value in subtraction (-) at /usr/local/astpp/astpp-common.pl line 3865. Use of uninitialized value in concatenation (.) or string at /usr/local/astpp/astpp-common.pl line 3866. UPDATE cdrs SET cost = 0 WHERE id = AND callednum = '00971508035911' DBD::mysql::db do failed: 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 'AND callednum = '00971508035911'' at line 1 at /usr/local/astpp/astpp- common.pl line 3870. ---------------------------------------------------------------------- >Comment By: Aleph Communications (darrenkw) Date: 2007-11-17 19:29 Message: Logged In: YES user_id=1227065 Originator: YES This was caused by your database not having a uniqueid tagged to each call. I'm closing it. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-11-03 16:34 Message: Logged In: YES user_id=1227065 Originator: YES I believe this was caused by your system not writing the uniqueids to the database. If so this is not an astpp bug. ---------------------------------------------------------------------- Comment By: Aleph Communications (darrenkw) Date: 2007-10-31 23:20 Message: Logged In: YES user_id=1227065 Originator: YES I'm not sure what's going on with this issue. Is it still happening? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=994546&aid=1800039&group_id=205663 |
