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` $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