[SR-Users] Siremis on Mysql and Kamailio on Postgresql

Victor Seva linuxmaniac at torreviejawireless.org
Thu Apr 12 13:47:37 CEST 2012


2012/4/12 Victor Seva <linuxmaniac at torreviejawireless.org>:
[...]
> These querys wont work with postgresql because the `table_name`.
[...]

As I said It seems to me that the problem is in openbiz:

root at zs2:/var/www# grep -n \` siremis-3.2.0/openbiz/bin/data/BizDataSql.php
49:        $this->_tableJoins = " `$mainTable` T0 ";
77:        $this->_tableJoins .= " $joinType `$table` $alias ON
$alias.$column = $aliasRef.$columnRef ";
248:                $this->_tableJoins .= " INNER JOIN `$xtable`
$xalias ON $xalias.$column2 = $mytable_col ";

Has anyone a working installation of siremis with kamailio on postgresql ?
Greetings



More information about the sr-users mailing list