From: <ar...@us...> - 2012-06-06 18:15:39
|
Revision: 41822 http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=41822&view=rev Author: arildb Date: 2012-06-06 18:15:33 +0000 (Wed, 06 Jun 2012) Log Message: ----------- [bp/r41821][FIX] invalid SQL syntax when UNION clause is used. Revision Links: -------------- http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=41821&view=rev Modified Paths: -------------- branches/9.x/lib/logs/logslib.php Modified: branches/9.x/lib/logs/logslib.php =================================================================== --- branches/9.x/lib/logs/logslib.php 2012-06-06 18:14:24 UTC (rev 41821) +++ branches/9.x/lib/logs/logslib.php 2012-06-06 18:15:33 UTC (rev 41822) @@ -461,7 +461,7 @@ $query_cant = "select count(distinct actionId) from `tiki_actionlog` a ,`tiki_actionlog_conf` c where $mid"; } - $query .= " order by a." . $this->convertSortMode($sort_mode); + $query .= " order by " . $this->convertSortMode($sort_mode); $result = $this->query($query, $bindvars, $maxRecords, $offset); $cant = $this->getOne($query_cant, $bindvars); $ret = array(); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |