From ba55f4a13938da61491aa9d081528e0b6f1c3416 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Fri, 30 Sep 2005 12:30:49 +0000
Subject: [PATCH] fix pgsql group conditiion

---
 .../serendipity_event_statistics.php                        | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/plugins/serendipity_event_statistics/serendipity_event_statistics.php b/plugins/serendipity_event_statistics/serendipity_event_statistics.php
index f4bee29..cfd5670 100644
--- a/plugins/serendipity_event_statistics/serendipity_event_statistics.php
+++ b/plugins/serendipity_event_statistics/serendipity_event_statistics.php
@@ -218,7 +218,7 @@ class serendipity_event_statistics extends serendipity_event
                                                     FROM {$serendipity['dbPrefix']}comments c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE e.id = c.entry_id AND type = 'NORMAL' AND subscribed = 'true'
-                                                    GROUP BY e.id, c.email, e.title
+                                                    GROUP BY e.id, c.email, e.title, e.timestamp
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
@@ -227,7 +227,7 @@ class serendipity_event_statistics extends serendipity_event
                                                     FROM {$serendipity['dbPrefix']}comments c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE e.id = c.entry_id AND type = 'NORMAL'
-                                                    GROUP BY e.id, e.title
+                                                    GROUP BY e.id, e.title, e.timestamp
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
@@ -243,7 +243,7 @@ class serendipity_event_statistics extends serendipity_event
                                                     FROM {$serendipity['dbPrefix']}comments c,
                                                          {$serendipity['dbPrefix']}entries e
                                                     WHERE e.id = c.entry_id AND type = 'TRACKBACK'
-                                                    GROUP BY e.id, e.title
+                                                    GROUP BY e.timestamp, e.id, e.title
                                                     ORDER BY postings DESC
                                                     LIMIT $max_items");
 
-- 
2.39.5