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.
Can you point me to a solution
-Thanks
[http://192.168.105.196/siremis/themes/default/images/icon_forbidden.gif] System Internal Error
The detailed error message are below:
[2012-07-26 19:14:11 (GMT)] An exception occurred while executing this script: Error message: #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' Script name and line number of error: /var/www/siremis-3.2.1/openbiz/bin/data/BizDataObj_Lite.php:447
function: _run_search ( Array(2) ) @ /var/www/siremis-3.2.1/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/FormRenderer.php 69 function: 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 function: render ( Object(EasyForm) ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/ViewRenderer.php 83 function: 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 function: render ( Object(EasyView) ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /var/www/siremis-3.2.1/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /var/www/siremis-3.2.1/openbiz/bin/BizController.php 221 function: renderView ( "sipuser.view.AccListView", "", "", Null, "" ) @ /var/www/siremis-3.2.1/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /var/www/siremis-3.2.1/openbiz/bin/BizController.php 32 function: include_once ( "/var/www/siremis-3.2.1/openbiz/bin/BizController.php" ) @ /var/www/siremis-3.2.1/siremis/bin/controller.php 6 function: include ( "/var/www/siremis-3.2.1/siremis/bin/controller.php" ) @ /var/www/siremis-3.2.1/siremis/bin/_forward.php 102 function: include ( "/var/www/siremis-3.2.1/siremis/bin/_forward.php" ) @ /var/www/siremis-3.2.1/siremis/index.php 3 ________________________________ Please ask system administrator for help...
Tony Ferrario Manager SVT & Ops OnMobile Global Limited 3950 Civic Center Drive , Suite 200 San Rafael, Ca 94903 Phone: 415-223-8206 Cell: 707-508-7285 tony.ferrario@onmobile.com
________________________________
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. Thank you - OnMobile Global Limited.