From 035bddda6904b8c168207c66246e26691a40a800 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Wed, 26 Oct 2005 08:58:42 +0000
Subject: [PATCH] fix bug in pgsql, thanks to captaincrunch from the forums

---
 docs/NEWS                       | 3 +++
 include/plugin_internal.inc.php | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

diff --git a/docs/NEWS b/docs/NEWS
index a4ee734..ac46a97 100644
--- a/docs/NEWS
+++ b/docs/NEWS
@@ -3,6 +3,9 @@
 Version 0.9-beta4 ()
 ------------------------------------------------------------------------
 
+    * Fix categories plugin to properly work on pgsql installations.
+      Thanks to CaptainCrunch!
+
     * Make serendipity_makeFilename function be UTF-8 aware.
 
     * Fix syndication plugin not allowing to configure Atom 1.0 feed.
diff --git a/include/plugin_internal.inc.php b/include/plugin_internal.inc.php
index 3b33d53..c81f719 100644
--- a/include/plugin_internal.inc.php
+++ b/include/plugin_internal.inc.php
@@ -1314,7 +1314,7 @@ class serendipity_categories_plugin extends serendipity_plugin {
                                                  {$serendipity['dbPrefix']}category c,
                                                  {$serendipity['dbPrefix']}entries e
                                             WHERE ec.categoryid = c.categoryid AND ec.entryid = e.id
-                                            GROUP BY ec.categoryid, c.category_name
+                                            GROUP BY c.categoryid, c.category_name
                                             ORDER BY postings DESC";
             $category_rows  = serendipity_db_query($cat_sql);
             if (is_array($category_rows)) {
-- 
2.39.5