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

[Victor Seva]

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