<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hi,<br>
<br>
On 11/12/2010 01:07 PM, X- x -X wrote:
<blockquote
cite="mid:AANLkTinC0dHn93L01h0T9p8vKCuUnSJ-5K8zLhJJOFw=@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
href="http://siremis.asipto.com/install-accounting/">http://siremis.asipto.com/install-accounting/</a>)</div>
<meta http-equiv="content-type"
content="text/html; charset=ISO-8859-1">
<div><br>
</div>
</blockquote>
the table is created when you install siremis 2.0 if you select the
check-box to update SIP database in web installation wizard:<br>
<br>
<a class="moz-txt-link-freetext" href="http://kb.asipto.com/siremis:install20:main#step_2">http://kb.asipto.com/siremis:install20:main#step_2</a><br>
<br>
Ramona<br>
<br>
<br>
<blockquote
cite="mid:AANLkTinC0dHn93L01h0T9p8vKCuUnSJ-5K8zLhJJOFw=@mail.gmail.com"
type="cite">
<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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
</body>
</html>