Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 2:32 pm
Predictive Dialer


All times are UTC




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: CDR table schema problem
PostPosted: Wed Sep 07, 2011 8:17 am 
Offline

Joined: Tue Feb 09, 2010 4:57 pm
Posts: 19
Hi,

There is a problem with CDR table schema (cc_call), the calledstation column is a VARCHAR with 30 characters length but depending on the situation it has to store incoming DID destination, this is a VARCHAR with 100 characters length. If destination is longer than 30 characters this results in string cut at 30 characters and the rest of the information is lost. For example when using trunks (like "SIP/the_name_of_my_trunk/000555000555") it's easy to exceed 30 characters.

I suggest a change in cc_call schema to match calledstation length to the information that can be stored in that column, in order to avoid losing information:

Code:
ALTER TABLE `cc_call` CHANGE `calledstation` `calledstation` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;


PD: I am unable to find where can I open a ticket in the tracker.

Thanks in advance.

Regards,


Top
 Profile  
 
 Post subject: Re: CDR table schema problem
PostPosted: Wed Sep 28, 2011 3:26 pm 
Offline

Joined: Sun Mar 12, 2006 2:49 pm
Posts: 954
Location: Barcelona
Thanks for the report, committed in :
https://github.com/Star2Billing/a2billi ... 1c5b8451fd

You can report bugs on :
https://github.com/Star2Billing/a2billing/issues

Yours,
/Areski


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 
VoIP Billing solution


All times are UTC


Who is online

Users browsing this forum: No registered users and 12 guests


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:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group