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=br...
Regards, Ramona
On 4/16/12 10:30 AM, Victor Seva wrote:
This patch seems to do the trick.
root@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` $xaliasON $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@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users