summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-03-05 14:52:35 +0000
committerCiaranG <ciaran@ciarang.com>2009-03-05 14:52:35 +0000
commitea0c5f565c9ca4b34c1071a51333f0f842a954b9 (patch)
tree38995bb8cf05de8e4001609684c84d641a1c86ab
parent0c066db428843a6ca969c8523f0be2bcdfa278f7 (diff)
The correct version of the bad fix I undid in the previous commit. Must explicitly specify all relevant columns in the GROUP BY.
-rw-r--r--lib/popularnoticesection.php4
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/popularnoticesection.php b/lib/popularnoticesection.php
index cbf458c34..0505f0fa9 100644
--- a/lib/popularnoticesection.php
+++ b/lib/popularnoticesection.php
@@ -57,7 +57,9 @@ class PopularNoticeSection extends NoticeSection
$qry = 'SELECT notice.*, '.
$weightexpr . ' as weight ' .
'FROM notice JOIN fave ON notice.id = fave.notice_id ' .
- 'GROUP BY notice.id ' .
+ 'GROUP BY notice.id,notice.profile_id,notice.content,notice.uri,' .
+ 'notice.rendered,notice.url,notice.created,notice.modified,' .
+ 'notice.reply_to,notice.is_local,notice.source ' .
'ORDER BY weight DESC';
$offset = 0;