<div><br></div><div>Hi all,</div><div>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.</div>
<div><br></div><div>Why is CDRS table missing ? Is it okay (advisable) to create a CDRS table mentioned in siremis 1.0 docs (<a href="http://siremis.asipto.com/install-accounting/">http://siremis.asipto.com/install-accounting/</a>)</div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><div><br></div><div>Cheers</div><div>---</div><div>X</div><div><br></div><div><br></div><div><br></div><div><br></div><div>[2010-11-12 14:01:08 (GMT)] An exception occurred while executing this script:</div>
<div>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</div>
<div>Script name and line number of error: /var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php:447</div><div><br></div><div>function: _run_search ( Array(2) ) @ /var/www/siremis-2.0.0/openbiz/bin/data/BizDataObj_Lite.php 243</div>
<div>function: fetch ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 690</div><div>function: fetchDataSet ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/FormRenderer.php 69</div><div>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</div>
<div>function: render ( Object(EasyForm) ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1648</div><div>function: renderHTML ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyForm.php 1538</div><div>function: render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/ViewRenderer.php 83</div>
<div>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</div><div>function: render ( Object(EasyView) ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 274</div>
<div>function: _render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/easy/EasyView.php 237</div><div>function: render ( ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php 221</div><div>function: renderView ( "ser.view.CdrsListView", "", "", Null, "" ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php 107</div>
<div>function: dispatchRequest ( ) @ /var/www/siremis-2.0.0/openbiz/bin/BizController.php 32</div><div>function: include_once ( "/var/www/siremis-2.0.0/openbiz/bin/BizController.php" ) @ /var/www/siremis-2.0.0/siremis/bin/controller.php 6</div>
<div>function: include ( "/var/www/siremis-2.0.0/siremis/bin/controller.php" ) @ /var/www/siremis-2.0.0/siremis/bin/_forward.php 90</div><div>function: include ( "/var/www/siremis-2.0.0/siremis/bin/_forward.php" ) @ /var/www/siremis-2.0.0/siremis/index.php 3</div>
<div>Please ask system administrator for help...</div>