# HG changeset patch
# User Dan
# Date 1239840338 14400
# Node ID 1064e7e57eeb8eab9911514a56a8074059cc8386
# Parent  05c341ea754576ac38b1a57a57b3617ad91c616b
Fixed logs not working under postgresql

diff -r 05c341ea7545 -r 1064e7e57eeb includes/log.php
--- a/includes/log.php	Wed Apr 15 19:53:06 2009 -0400
+++ b/includes/log.php	Wed Apr 15 20:05:38 2009 -0400
@@ -148,10 +148,14 @@
     {
       $where_extra .= "\n    AND ( (" . implode(") OR (", $where_bits['action']) . ") )";
     }
-    $limit = ( $page_size > 0 ) ? "\n  LIMIT $offset, $page_size" : '';
+    if ( ENANO_DBLAYER == 'PGSQL' )
+      $limit = ( $page_size > 0 ) ? "\n  LIMIT $page_size OFFSET $offset" : '';
+    else
+      $limit = ( $page_size > 0 ) ? "\n  LIMIT $offset, $page_size" : '';
     $columns = ( $just_page_count ) ? 'COUNT(*)' : 'log_id, action, page_id, namespace, CHAR_LENGTH(page_text) AS revision_size, author, time_id, edit_summary, minor_edit';
-    $sql = 'SELECT ' . $columns . ' FROM ' . table_prefix . "logs\n"
+    $sql = 'SELECT ' . $columns . ' FROM ' . table_prefix . "logs AS l\n"
          . "  WHERE log_type = 'page' AND is_draft != 1$where_extra\n"
+         . "  GROUP BY log_id, action, page_id, namespace, page_text, author, time_id, edit_summary, minor_edit"
          . "  ORDER BY log_id DESC $limit;";
     
     return $sql;