From c96097529e49943eddba78d70e23e38c0eac494d Mon Sep 17 00:00:00 2001
From: nikrou <nikrou@piwigo.org>
Date: Sun, 29 Nov 2009 12:35:19 +0000
Subject: Feature_1255 : - single quotes in queries - start using
 $conf['dblayer']

git-svn-id: http://piwigo.org/svn/trunk@4385 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 comments.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'comments.php')

diff --git a/comments.php b/comments.php
index 3d8c9cccf..c020a84ce 100644
--- a/comments.php
+++ b/comments.php
@@ -321,7 +321,8 @@ SELECT com.id AS comment_id
     ON u.'.$conf['user_fields']['id'].' = com.author_id
   WHERE '.implode('
     AND ', $page['where_clauses']).'
-  GROUP BY comment_id
+  GROUP BY comment_id, com.image_id, ic.category_id, com.author, 
+           com.author_id, com.date, com.content, com.validated
   ORDER BY '.$page['sort_by'].' '.$page['sort_order'];
 if ('all' != $page['items_number'])
 {
-- 
cgit v1.2.3