[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