diff options
| author | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-01-20 12:26:50 +0000 |
|---|---|---|
| committer | ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-01-20 12:26:50 +0000 |
| commit | 358cf53e56498882a6870e06c58328742c9d8ed9 (patch) | |
| tree | 7a68d7a2f5c8c1879ed325b0a6f41d875d358646 /engine | |
| parent | 7fe851390bed54f4f8a0937436d61277c1f0ce7c (diff) | |
| download | elgg-358cf53e56498882a6870e06c58328742c9d8ed9.tar.gz elgg-358cf53e56498882a6870e06c58328742c9d8ed9.tar.bz2 | |
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
Diffstat (limited to 'engine')
| -rw-r--r-- | engine/lib/annotations.php | 3 |
1 files changed, 2 insertions, 1 deletions
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");
}
|