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...

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users