From f9f6b8e23a842d2e53e185a7cf83f0549cc5a973 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Fri, 14 Oct 2005 10:09:59 +0000
Subject: [PATCH] postgresql fix by CaptainCrunch from the forums. Thanks!

---
 plugins/serendipity_event_karma/serendipity_event_karma.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/plugins/serendipity_event_karma/serendipity_event_karma.php b/plugins/serendipity_event_karma/serendipity_event_karma.php
index ea137d5..4d6d5fb 100644
--- a/plugins/serendipity_event_karma/serendipity_event_karma.php
+++ b/plugins/serendipity_event_karma/serendipity_event_karma.php
@@ -65,7 +65,7 @@ class serendipity_event_karma extends serendipity_event
         $propbag->add('description',   PLUGIN_KARMA_BLAHBLAH);
         $propbag->add('stackable',     false);
         $propbag->add('author',        'Garvin Hicking');
-        $propbag->add('version',       '1.5');
+        $propbag->add('version',       '1.6');
         $propbag->add('requirements',  array(
             'serendipity' => '0.8',
             'smarty'      => '2.6.7',
@@ -392,7 +392,7 @@ class serendipity_event_karma extends serendipity_event
                                      AS e
                                   ON k.entryid = e.id
                             WHERE k.{$rows[0]} IS NOT NULL AND k.{$rows[0]} != 0
-                            GROUP BY e.id, e.title ORDER BY no {$rows[1]} LIMIT {$addData['maxitems']}";
+                            GROUP BY e.id, e.title, e.timestamp ORDER BY no {$rows[1]} LIMIT {$addData['maxitems']}";
                         $sql_rows = serendipity_db_query($q);
 ?>
     <dt><strong><?php echo constant('PLUGIN_KARMA_STATISTICS_' . strtoupper($key)); ?></strong></dt>
-- 
2.39.5