- Patch #102151 by robert douglass: removed unneeded 'GROUP BY' clause in thread-building code.

1 files changed, 1 insertions, 3 deletions

diff --git a/modules/comment/comment.module b/modules/comment/comment.module
index 0607f2931..f75c9399c 100644
--- a/modules/comment/comment.module
+++ b/modules/comment/comment.module
@@ -831,7 +831,7 @@ function comment_render($node, $cid = 0) {
         $query .= ' AND c.status = %d';
         $query_args[] = COMMENT_PUBLISHED;
       }
-      $query .= ' GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.status';
+
       $result = db_query($query, $query_args);
 
       if ($comment = db_fetch_object($result)) {
@@ -858,8 +858,6 @@ function comment_render($node, $cid = 0) {
         $query_args[] = COMMENT_PUBLISHED;
       }
 
-      $query .= ' GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.thread, c.status';
-
       if ($order == COMMENT_ORDER_NEWEST_FIRST) {
         if ($mode == COMMENT_MODE_FLAT_COLLAPSED || $mode == COMMENT_MODE_FLAT_EXPANDED) {
           $query .= ' ORDER BY c.timestamp DESC';