<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
</head>
<body>
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">I just installed a Siremis 3.2.1 on a server with an already working Kamailio 3.2.1. bellow is a typical error message I keep getting.
<br>
<br>
Can you point me to a solution<br>
<br>
<br>
-Thanks<br>
<br>
<br>
<div style="height:35px">
<div style="float:left; width:50px"><img src="http://192.168.105.196/siremis/themes/default/images/icon_forbidden.gif"></div>
<div style="float:left">
<h1>System Internal Error</h1>
</div>
</div>
<div id="detailed_error_msg" style="display:block">
<p class="input_row" style="height:25px; line-height:20px"><label style="width:40px; height:25px"></label><span>The detailed error message are below:</span>
</p>
<div style="height:170px">
<div class="system_error_msg">
<div style="width:440px; padding:10px 20px 10px 20px">
<div style="font-size:12px; color:blue; font-family:Arial; font-weight:bold">[2012-07-26 19:14:11 (GMT)] An exception occurred while executing this script:<br>
Error message: <font color="maroon">#0, Error in query:: SELECT T0.id, T0.method, T0.from_tag, T0.to_tag, T0.callid, T0.sip_code, T0.sip_reason, T0.time, T0.src_ip, T0.dst_user, T0.dst_domain, T0.dst_ouser, T0.src_user, T0.src_domain, T0.cdr_id FROM `acc` T0
WHERE method='INVITE' AND T0.src_user='admin' LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.src_ip' in 'field list'</font><br>
Script name and line number of error: <font color="maroon">/var/www/siremis-3.2.1/openbiz/bin/data/BizDataObj_Lite.php:447</font><br>
<div style="font-weight:normal"><br>
<b>function:</b> _run_search ( Array(2) ) @ /var/www/siremis-3.2.1/openbiz/bin/data/BizDataObj_Lite.php 243
<br>
<b>function:</b> fetch ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyForm.php 690
<br>
<b>function:</b> fetchDataSet ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/FormRenderer.php 69
<br>
<b>function:</b> renderSmarty ( Object(EasyForm), "/var/www/siremis-3.2.1/siremis/modules/sipuser/template/grid.tpl" ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/FormRenderer.php 45
<br>
<b>function:</b> render ( Object(EasyForm) ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyForm.php 1648
<br>
<b>function:</b> renderHTML ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyForm.php 1538
<br>
<b>function:</b> render ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/ViewRenderer.php 83
<br>
<b>function:</b> renderSmarty ( Object(EasyView), "/var/www/siremis-3.2.1/siremis/modules/sipuser/template/view.tpl" ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/ViewRenderer.php 40
<br>
<b>function:</b> render ( Object(EasyView) ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyView.php 274
<br>
<b>function:</b> _render ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyView.php 237
<br>
<b>function:</b> render ( ) @ /var/www/siremis-3.2.1/openbiz/bin/BizController.php 221
<br>
<b>function:</b> renderView ( "sipuser.view.AccListView", "", "", Null, "" ) @ /var/www/siremis-3.2.1/openbiz/bin/BizController.php 107
<br>
<b>function:</b> dispatchRequest ( ) @ /var/www/siremis-3.2.1/openbiz/bin/BizController.php 32
<br>
<b>function:</b> include_once ( "/var/www/siremis-3.2.1/openbiz/bin/BizController.php" ) @ /var/www/siremis-3.2.1/siremis/bin/controller.php 6
<br>
<b>function:</b> include ( "/var/www/siremis-3.2.1/siremis/bin/controller.php" ) @ /var/www/siremis-3.2.1/siremis/bin/_forward.php 102
<br>
<b>function:</b> include ( "/var/www/siremis-3.2.1/siremis/bin/_forward.php" ) @ /var/www/siremis-3.2.1/siremis/index.php 3</div>
<hr>
Please ask system administrator for help...</div>
</div>
</div>
</div>
</div>
<br>
<div><br>
<div class="BodyFragment"><font size="2">
<div class="PlainText">Tony Ferrario<br>
Manager SVT & Ops<br>
OnMobile Global Limited <br>
3950 Civic Center Drive , Suite 200<br>
San Rafael, Ca 94903 <br>
Phone: 415-223-8206<br>
Cell: 707-508-7285<br>
tony.ferrario@onmobile.com</div>
</font></div>
</div>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, or distribution
of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Further, this e-mail may contain viruses and all reasonable precaution
to minimize the risk arising there from is taken by OnMobile. OnMobile is not liable for any damage sustained by you as a result of any virus in this e-mail. All applicable virus checks should be carried out by you before opening this e-mail or any attachment
thereto.<br>
Thank you - OnMobile Global Limited.<br>
</font>
</body>
</html>