siremis 2.0.0 CDRS link issues ! - sr-users

12 Nov 2010

Hi all,
I was wondering if Im the only one getting this error (in siremis 2.0.0 with
kamailio 3.1). i.e. I have activated the accounting modules & all but still
when I click the "CDR list" in "Accounting Services" it errors on me
saying
that CDRS table is missing, which ofcourse is missing from the "openser"
mysql DB.

Why is CDRS table missing ? Is it okay (advisable) to create a CDRS table
mentioned in siremis 1.0 docs (http://siremis.asipto.com/install-accounting/
)

Cheers
---
X

[2010-11-12 14:01:08 (GMT)] An exception occurred while executing this
script:
Error message: #0, Error in query:: SELECT T0.cdr_id, T0.src_username,
T0.src_domain, T0.dst_username, T0.dst_domain, T0.call_start_time,
T0.duration, T0.sip_call_id, T0.sip_from_tag, T0.sip_to_tag, T0.src_ip,
T0.cost, T0.created FROM `cdrs` T0 LIMIT 10. SQLSTATE[42S02]: Base table or
view not found: 1146 Table 'openser.cdrs' doesn't exist
Script name and line number of error:
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447

function: _run_search ( Array(2) ) @
/var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php 243
function: fetch ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php
690
function: fetchDataSet ( ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 69
function: renderSmarty ( Object(EasyForm),
"/var/www/siremis-2.0.0/siremis/modules/ser/template/grid.tpl" ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 45
function: render ( Object(EasyForm) ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1648
function: renderHTML ( ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1538
function: render ( ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 83
function: renderSmarty ( Object(EasyView),
"/var/www/siremis-2.0.0/siremis/modules/ser/template/view.tpl" ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 40
function: render ( Object(EasyView) ) @
/var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 274
function: _render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php
237
function: render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php
221
function: renderView ( "ser.view.CdrsListView", "", "",
Null, "" ) @
/var/www/siremis-2.0.0/openbiz/bin/BizController.php 107
function: dispatchRequest ( ) @
/var/www/siremis-2.0.0/openbiz/bin/BizController.php 32
function: include_once (
"/var/www/siremis-2.0.0/openbiz/bin/BizController.php" ) @
/var/www/siremis-2.0.0/siremis/bin/controller.php 6
function: include ( "/var/www/siremis-2.0.0/siremis/bin/controller.php" ) @
/var/www/siremis-2.0.0/siremis/bin/_forward.php 90
function: include ( "/var/www/siremis-2.0.0/siremis/bin/_forward.php" ) @
/var/www/siremis-2.0.0/siremis/index.php 3
Please ask system administrator for help...