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 -- Daniel-Constantin Mierla http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda Kamailio World Conference, May 27-29, 2015 Berlin, Germany - http://www.kamailioworld.com _______________________________________________ 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
