Hi,
On 11/12/2010 01:07 PM, X- x -X wrote:
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/)
the table is created when you install siremis 2.0 if you select the
check-box to update SIP database in web installation wizard:
http://kb.asipto.com/siremis:install20:main#step_2
Ramona
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
_______________________________________________
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
