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(a)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