[Astpp-tracker] [ astpp-Bugs-1800039 ] Call rating issue

Bugs item #1800039, was opened at 2007-09-21 19:27
Message generated for change (Settings changed) 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: Closed
>Resolution: Rejected
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