Hello,

you have to look at upgrade guidelines from your old version (3.1) to the new one (4.1):

- http://www.kamailio.org/wiki/start#upgrade

The database structure of kamailio has changed, you must get the one for version 4.1.

Cheers, Daniel

On 05/02/15 20:00, Marek Moravcik wrote:

Hello,

after upgrading Siremis from 3.1 to 4.1 he starts report SQL errors on more places. But most annoying is error in domain list. I've tried to reinstall Siremis, drop database, but nothing helps. On other server after same upgrade, everything goes well. Only difference is, that error server has 64 bit architecture. Both servers have Kamailio 4.2.1. Where shall I look for problem?

Here is domain list error:

[2015-02-05 18:45:32 (GMT)] An exception occurred while executing this script: Error message: #0, Error in query:: SELECT T0.id, T0.domain, T0.did, T0.last_modified FROM domain T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.did' in 'field list' Script name and line number of error: /home/palo/sip/openbiz/bin/data/BizDataObj_Lite.php:447

function: _run_search ( Array(2) ) @ /home/palo/sip/openbiz/bin/data/BizDataObj_Lite.php 243 function: fetch ( ) @ /home/palo/sip/openbiz/bin/easy/EasyForm.php 690 function: fetchDataSet ( ) @ /home/palo/sip/openbiz/bin/easy/FormRenderer.php 69 function: renderSmarty ( Object(EasyForm), "/home/palo/sip/siremis/modules/ser/template..." ) @ /home/palo/sip/openbiz/bin/easy/FormRenderer.php 45 function: render ( Object(EasyForm) ) @ /home/palo/sip/openbiz/bin/easy/EasyForm.php 1648 function: renderHTML ( ) @ /home/palo/sip/openbiz/bin/easy/EasyForm.php 1538 function: render ( ) @ /home/palo/sip/openbiz/bin/easy/ViewRenderer.php 83 function: renderSmarty ( Object(EasyView), "/home/palo/sip/siremis/modules/ser/template..." ) @ /home/palo/sip/openbiz/bin/easy/ViewRenderer.php 40 function: render ( Object(EasyView) ) @ /home/palo/sip/openbiz/bin/easy/EasyView.php 274 function: _render ( ) @ /home/palo/sip/openbiz/bin/easy/EasyView.php 237 function: render ( ) @ /home/palo/sip/openbiz/bin/BizController.php 221 function: renderView ( "ser.view.DomainListView", "", "", Null, "" ) @ /home/palo/sip/openbiz/bin/BizController.php 107 function: dispatchRequest ( ) @ /home/palo/sip/openbiz/bin/BizController.php 32 function: include_once ( "/home/palo/sip/openbiz/bin/BizController.ph..." ) @ /home/palo/sip/siremis/bin/controller.php 6 function: include ( "/home/palo/sip/siremis/bin/controller.php" ) @ /home/palo/sip/siremis/bin/_forward.php 102 function: include ( "/home/palo/sip/siremis/bin/_forward.php" ) @ /home/palo/sip/siremis/index.php 3

Thanks! Marek Moravcik

---

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