[SR-Users] Siremis domain querry reports SQL error

[Marek Moravcik]

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