[SR-Users] siremis 2.0.0 CDRS link issues !

[Elena-Ramona Modroiu]

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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>    

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20101115/94fdf465/attachment.htm>