asterisk2billing.org
http://forum.asterisk2billing.org/

A2billing 2.0.16 don't store cdr logs
http://forum.asterisk2billing.org/viewtopic.php?f=22&t=11070
Page 1 of 1

Author:  mettichi [ Fri Dec 19, 2014 6:17 am ]
Post subject:  A2billing 2.0.16 don't store cdr logs

Hello,

i have updated Abilling to the last version 2.0.26 every thing works good just the call log
when i access to the call report i always get the message : no data found, i have checked httpd logs
i found these en error.log

referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: mydisplaylimit in /usr/src/common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: filterprefix in common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: cssname in /common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: popup_select in /common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: popup_formname in /common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: popup_fieldname in common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: ui_language in /common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: msg in /common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] ] PHP Notice: Undefined variable: section in common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0
[Thu Dec 18 23:57:44 2014] [error] PHP Notice: Undefined variable: cssname in common/lib/Misc.php on line 362, referer: Public/call-log-customers.php?s=1&t=0&order=t1.starttime&sens=DESC&current_page=0


can someone help me please?

Thanks in advance

Author:  jroper [ Fri Dec 19, 2014 11:02 am ]
Post subject:  Re: A2billing 2.0.16 don't store cdr logs

Hi

Make sure the data schema is as it should be for the cc_call table, particularly for version 2.0.13 or later where two new fields were added.

Joe

Author:  jansalex [ Fri Jan 09, 2015 8:48 am ]
Post subject:  Re: A2billing 2.0.16 don't store cdr logs

Hi,

how you solved this problem ?. I'm in the same scenario A2billing 2.0.16.

Thanks.

Author:  jansalex [ Tue Jan 13, 2015 5:20 pm ]
Post subject:  Re: A2billing 2.0.16 don't store cdr logs

Is this cc_call table correct for the 2.0.16 version ?, are here the new fileds you said ?




id bigint(20) No Primaria NULL auto_increment
sessionid varchar(40) No Ninguna NULL
uniqueid varchar(30) No Ninguna NULL
card_id bigint(20) No Ninguna NULL
nasipaddress varchar(30) No Ninguna NULL
starttime timestamp No Indizada CURRENT_TIMESTAMP
stoptime timestamp No Ninguna 0000-00-00 00:00:00
sessiontime int(11) Si Ninguna NULL
calledstation varchar(100) No Indizada NULL
sessionbill float Si Ninguna NULL
id_tariffgroup int(11) Si Ninguna NULL
id_tariffplan int(11) Si Ninguna NULL
id_ratecard int(11) Si Ninguna NULL
id_trunk int(11) Si Ninguna NULL
sipiax int(11) Si Ninguna 0
src varchar(40) No Ninguna NULL
id_did int(11) Si Ninguna NULL
buycost decimal(15,5) Si Ninguna 0.00000
id_card_package_offer int(11) Si Ninguna 0
real_sessiontime int(11) Si Ninguna NULL
dnid varchar(40) No Ninguna NULL
terminatecauseid int(1) Si Indizada 1
destination int(11) Si Ninguna 0

Author:  jroper [ Tue Jan 13, 2015 6:19 pm ]
Post subject:  Re: A2billing 2.0.16 don't store cdr logs

No

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/