Fix bug #4947: SQL error with DBAL/PostgreSQL when listing or looking up reviewed...

git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@2034 709f56b5-9817-0410-a4d7-c38de5d9e867

diff --git a/ChangeLog b/ChangeLog
index 9e50f83..853b142 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,8 @@
+
+2007-02-15  Martin Kutschker  <martin.t.kutschker@blackbox.net>
+
+       * Fix bug #4947: SQL error with DBAL/PostgreSQL when listing or looking up reviewed extensions
+
 2007-02-15  Thorsten Kahler  <thorsten.kahler@dkd.de>
 
        * Fix: Display description of options in install tool correctly

diff --git a/typo3/mod/tools/em/class.em_xmlhandler.php b/typo3/mod/tools/em/class.em_xmlhandler.php
index 75ce2a0..139b6ba 100644 (file)
--- a/typo3/mod/tools/em/class.em_xmlhandler.php
+++ b/typo3/mod/tools/em/class.em_xmlhandler.php
@@ -104,13 +104,11 @@ class SC_mod_tools_em_xmlhandler {
                }
 
                        // Fetch count
-               $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('count(*) as cnt', 'cache_extensions', $where, '', $order);
+               $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('count(*) as cnt', 'cache_extensions', $where);
                $row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
                $this->matchingCount = $row['cnt'];
                $GLOBALS['TYPO3_DB']->sql_free_result($res);
 
-               $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('count(*) as cnt', 'cache_extensions', $where, '', $order);
-
                $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('*', 'cache_extensions', $where, '', $order, $offset.','.$limit);
                $this->extensionsXML = array();
                while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res))      {
@@ -600,4 +598,4 @@ class SC_mod_tools_em_xmlhandler {
                }
        }
 }
-?>
\ No newline at end of file
+?>