Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Mon Oct 21, 2019 10:51 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: cdr report shows erratic destinations
PostPosted: Mon Mar 30, 2009 2:46 am 
Offline

Joined: Fri Aug 29, 2008 3:14 pm
Posts: 29
since some trunk versions, cdr report is showing incorrect destinations

sometimes shows a different destination (eg calling spain mobile shows brazil mobile) other times shows a number. (dialing 13052XXXX shows 55253)


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 30, 2009 2:53 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
Are these new CDRs written by v1.4, or were they upgraded from a v1.3 installation?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 30, 2009 3:23 pm 
Offline

Joined: Fri Aug 29, 2008 3:14 pm
Posts: 29
upgraded to 1.4 in november.

the CDR ws all fine until two weeks ago.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 30, 2009 3:33 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
OK, so what changed two weeks ago?
Did you upgrade A2B? Or anything else on your system? What configuration changes did you make at the time the CDRs ceased to work.

If you haven't tried the version of A2B in trunk today, you should upgrade and re-test.

Please always mention which svn revision you are working with when reporting a problem with an unreleased version.


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 30, 2009 4:20 pm 
Offline

Joined: Fri Aug 29, 2008 3:14 pm
Posts: 29
only upgraded a2b...


upgraded every day. and since two weeks cdr are bad displaying.

just made a svn up and things are still the same.

after every update, i look in the mysql script and apply the mysql updates by hand.

may be i missed one? can anybody post the cc_call structure to see if it differs?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Mar 30, 2009 4:21 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
Look in the Database folder; you already have it.


Top
 Profile  
 
 Post subject: fixed
PostPosted: Mon Mar 30, 2009 6:24 pm 
Offline

Joined: Fri Aug 29, 2008 3:14 pm
Posts: 29
yes, i have the UPDATE-....sql with the initial table and all the updates. i am asking for the final table to see if it differs. (may be i forgot an option)

Added after 1 minutes:

opss.. sorry. i have also the schema....

Added after 15 minutes:



tables are identical in the schema and in my DB. (both cc_call and cc_prefix)

in the cc_call the prefixes are fine

in the trac i have found a similar ticket (http://www.asterisk2billing.org/cgi-bin ... ticket/421)

seems the same problem.

Added after 49 minutes:

mmm. just wrote an small php script to make a csv from the call report and is reading fine the tables.

is there any qick way to debug the sql query in the cdr report?

Added after 10 minutes:


just checked.

The oproblem shows in the admin UI and in the agent UI, but the destinations are correct in the customer UI.

Added after 41 minutes:

fixed now.
the t1.id_ratecard should be t1.destination



--- call-log-customers.php (revisi´┐Żn: 1788)
+++ call-log-customers.php (copia de trabajo)
@@ -96,7 +96,7 @@
}

// This Variable store the argument for the SQL query
-$FG_COL_QUERY = 't1.starttime, t1.src, t1.dnid ,t1.calledstation,t1.id_ratecard, t4.buyrate ,t4.rateinitial ,t1.sessiontime, t1.card_id, t3.trunkcode, t1.terminatecauseid, t1.sipiax, t1.buycost, t1.sessionbill, case when t1.sessionbill!=0 then ((t1.sessionbill-t1.buycost)/t1.sessionbill)*100 else NULL end as margin,case when t1.buycost!=0 then ((t1.sessionbill-t1.buycost)/t1.buycost)*100 else NULL end as markup';
+$FG_COL_QUERY = 't1.starttime, t1.src, t1.dnid ,t1.calledstation,t1.destination, t4.buyrate ,t4.rateinitial ,t1.sessiontime, t1.card_id, t3.trunkcode, t1.terminatecauseid, t1.sipiax, t1.buycost, t1.sessionbill, case when t1.sessionbill!=0 then ((t1.sessionbill-t1.buycost)/t1.sessionbill)*100 else NULL end as margin,case when t1.buycost!=0 then ((t1.sessionbill-t1.buycost)/t1.buycost)*100 else NULL end as markup';
if (LINK_AUDIO_FILE) {
$FG_COL_QUERY .= ', t1.uniqueid';


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 
Voice Broadcast System


All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group