[Librefm-commits] [1352] try proper grouping

[Clint Adams]

Revision: 1352
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1352
Author:   clint
Date:     2009-05-08 03:27:13 +0000 (Fri, 08 May 2009)
Log Message:
-----------
try proper grouping

Modified Paths:
--------------
    trunk/nixtape/data/Group.php

Modified: trunk/nixtape/data/Group.php
===================================================================
--- trunk/nixtape/data/Group.php        2009-05-08 03:14:45 UTC (rev 1351)
+++ trunk/nixtape/data/Group.php        2009-05-08 03:27:13 UTC (rev 1352)
@@ -206,7 +206,7 @@
                                ."INNER JOIN (SELECT g.groupname, g.owner, 
g.fullname, g.bio, g.homepage, g.created, g.modified, g.avatar_uri, 
g.grouptype, COUNT(*) AS member_count "
                                ."FROM Groups g "
                                ."LEFT JOIN Group_Members gm ON gm.grp=g.id "
-                               ."GROUP BY g.id, g.owner, g.fullname, g.bio, 
g.homepage, g.created, g.modified, g.avatar_uri, g.grouptype) gc "
+                               ."GROUP BY g.groupname, g.owner, g.fullname, 
g.bio, g.homepage, g.created, g.modified, g.avatar_uri, g.grouptype) gc "
                                ."ON m.grp=gc.id "
                                ."WHERE 
m.member=".$mdb2->quote($user->uniqueid, 'integer'));
                }