[geeklog-hg] geeklog: fixed GROUP BY for Postgres

[geeklog-cvs at lists.geeklog.net]

changeset 8743:aab665d998ef
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/aab665d998ef
user: Dirk Haun <dirk at haun-online.de>
date: Sat Jun 30 13:05:59 2012 +0200
description:
fixed GROUP BY for Postgres

diffstat:

 public_html/admin/story.php |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r a7a99d84a74d -r aab665d998ef public_html/admin/story.php
--- a/public_html/admin/story.php	Sat Jun 30 12:13:28 2012 +0200
+++ b/public_html/admin/story.php	Sat Jun 30 13:05:59 2012 +0200
@@ -214,7 +214,7 @@
     $query_arr = array(
         'table' => 'stories',
         'sql' => $sql,
-        'query_group' => 'sid',
+        'query_group' => "sid,{$_TABLES['users']}.username,{$_TABLES['users']}.fullname",
         'query_fields' => array('title', 'introtext', 'bodytext', 'sid', 'tid'),
         'default_filter' => $excludetopics . COM_getPermSQL('AND')
     );