From 358cf53e56498882a6870e06c58328742c9d8ed9 Mon Sep 17 00:00:00 2001 From: ben Date: Tue, 20 Jan 2009 12:26:50 +0000 Subject: Added the missing 'group by' clause to the get annotations by sum SQL query. git-svn-id: https://code.elgg.org/elgg/trunk@2584 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/annotations.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/engine/lib/annotations.php b/engine/lib/annotations.php index 674af14b1..94e5381ce 100644 --- a/engine/lib/annotations.php +++ b/engine/lib/annotations.php @@ -648,7 +648,8 @@ $query .= get_access_sql_suffix("a"); // now add access $query .= ' and ' . get_access_sql_suffix("e"); // now add access $query .= ' order by sum ' . $orderdir; - + $query .= ' group by e.guid'; + return get_data($query, "entity_row_to_elggstar"); } -- cgit v1.2.3