[SR-Users] Siremis domain querry reports SQL error

Daniel-Constantin Mierla miconda at gmail.com
Fri Feb 6 09:53:55 CET 2015


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 at 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




More information about the sr-users mailing list