From 1e4c8535efc7ef27aa96f703865c89ed183d8583 Mon Sep 17 00:00:00 2001
From: sam_marshall <sam_marshall>
Date: Wed, 4 Oct 2006 10:03:02 +0000
Subject: [PATCH] Wiki - fixed 'Strip versions' that didn't work in postgres
 because of GROUP BY a select alias not being allowed. (Even tested in mysql
 this time...)

---
 mod/wiki/ewikimoodlelib.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/mod/wiki/ewikimoodlelib.php b/mod/wiki/ewikimoodlelib.php
index b2cb2d2e58..133f9a7401 100644
--- a/mod/wiki/ewikimoodlelib.php
+++ b/mod/wiki/ewikimoodlelib.php
@@ -167,7 +167,7 @@ function ewiki_database_moodle($action, &$args, $sw1, $sw2) {
          $sql= "SELECT pagename AS id, count(*) as versioncount".
             " FROM ". $CFG->prefix.EWIKI_DB_TABLE_NAME .
             " WHERE wiki = ".$wiki_entry->id.
-            " GROUP BY id";
+            " GROUP BY pagename";
 
          #print "$sql";
          $result=get_records_sql($sql);
-- 
2.39.5