summaryrefslogtreecommitdiff
path: root/actions
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-03-09 20:24:56 +0000
committerCiaranG <ciaran@ciarang.com>2009-03-09 20:24:56 +0000
commit945bbf00dc9ee106359e9387956c72c1290d12fc (patch)
tree6a681fb49c888e6f5b2071efbe315d8810a52d09 /actions
parent8d3d16f2f8fbbffc6824efcee4bd0ce25b314e14 (diff)
PostgreSQL - a couple more GROUP BY queries that needed to be explicit
Diffstat (limited to 'actions')
-rw-r--r--actions/favorited.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/actions/favorited.php b/actions/favorited.php
index 5082f4a4e..231b97897 100644
--- a/actions/favorited.php
+++ b/actions/favorited.php
@@ -178,7 +178,7 @@ class FavoritedAction extends Action
$qry = 'SELECT notice.*, '.
$weightexpr . ' as weight ' .
'FROM notice JOIN fave ON notice.id = fave.notice_id ' .
- 'GROUP BY fave.notice_id ' .
+ 'GROUP BY id,profile_id,uri,content,rendered,url,created,notice.modified,reply_to,is_local,source ' .
'ORDER BY weight DESC';
$offset = ($this->page - 1) * NOTICES_PER_PAGE;