[SR-Users] Siremis on Mysql and Kamailio on Postgresql
Elena-Ramona Modroiu
ramona at asipto.com
Mon Apr 16 22:27:03 CEST 2012
Hi,
the patch is to phpopenbiz framework, which is not included in siremis
git repository. But we can include the patch itself and document it, can
you add it as attachment to sourceforge tracker?
http://sourceforge.net/tracker/?atid=3020101&group_id=250738&func=browse
Regards,
Ramona
On 4/16/12 10:30 AM, Victor Seva wrote:
> This patch seems to do the trick.
>
> root at zs2:/var/www/siremis-3.2.0# diff -ruN
> openbiz/bin/data/BizDataSql.php~ openbiz/bin/data/BizDataSql.php
> --- openbiz/bin/data/BizDataSql.php~ 2010-09-15 15:09:29.000000000 +0200
> +++ openbiz/bin/data/BizDataSql.php 2012-04-16 10:23:38.000000000 +0200
> @@ -46,7 +46,7 @@
> public function addMainTable($mainTable)
> {
> $this->_mainTable = "$mainTable";
> - $this->_tableJoins = " `$mainTable` T0 ";
> + $this->_tableJoins = " $mainTable T0 ";
> }
>
> /**
> @@ -74,7 +74,7 @@
> $this->_joinAliasList[$tableJoin->m_Name] = $alias;
> $this->_tableAliasList[$table] = $alias;
> $aliasRef = $this->getJoinAlias($joinRef);
> - $this->_tableJoins .= " $joinType `$table` $alias ON
> $alias.$column = $aliasRef.$columnRef ";
> + $this->_tableJoins .= " $joinType $table $alias ON
> $alias.$column = $aliasRef.$columnRef ";
> }
>
> /**
> @@ -245,7 +245,7 @@
> //if (strpos($this->m_TableJoins, "JOIN $xtable") === false)
> if (!isset($this->_tableAliasList[$xtable]))
> {
> - $this->_tableJoins .= " INNER JOIN `$xtable` $xalias
> ON $xalias.$column2 = $mytable_col ";
> + $this->_tableJoins .= " INNER JOIN $xtable $xalias ON
> $xalias.$column2 = $mytable_col ";
> $this->_tableAliasList[$xtable] = $xalias;
> }
> // add a new where condition
>
> _______________________________________________
> 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
>
More information about the sr-users
mailing list