| asterisk2billing.org http://forum.asterisk2billing.org/ |
|
| CDR table schema problem http://forum.asterisk2billing.org/viewtopic.php?f=34&t=9143 |
Page 1 of 1 |
| Author: | a2user [ Wed Sep 07, 2011 8:17 am ] |
| Post subject: | CDR table schema problem |
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, |
|
| Author: | areski [ Wed Sep 28, 2011 3:26 pm ] |
| Post subject: | Re: CDR table schema problem |
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 |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|