aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorHabeas Codice <habeascodice@federated.social>2015-01-28 17:36:24 -0800
committerHabeas Codice <habeascodice@federated.social>2015-01-28 17:36:24 -0800
commit435509f6092e55c7f1d96be23519f67c4db511ad (patch)
treec2935b8db7e1dbe1e3a7be735944b4153e5b78c2
parent64181abc6f46085a3772166cfdaa427fce4722ed (diff)
downloadvolse-hubzilla-435509f6092e55c7f1d96be23519f67c4db511ad.tar.gz
volse-hubzilla-435509f6092e55c7f1d96be23519f67c4db511ad.tar.bz2
volse-hubzilla-435509f6092e55c7f1d96be23519f67c4db511ad.zip
fix improper group by usage
-rw-r--r--include/chat.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/include/chat.php b/include/chat.php
index 533c03dde..b19d495bb 100644
--- a/include/chat.php
+++ b/include/chat.php
@@ -185,7 +185,7 @@ function chatroom_list($uid) {
require_once('include/security.php');
$sql_extra = permissions_sql($uid);
- $r = q("select cr_name, cr_id, count(cp_id) as cr_inroom from chatroom left join chatpresence on cr_id = cp_room where cr_uid = %d $sql_extra group by cr_name order by cr_name",
+ $r = q("select cr_name, cr_id, count(cp_id) as cr_inroom from chatroom left join chatpresence on cr_id = cp_room where cr_uid = %d $sql_extra group by cr_name, cr_id order by cr_name",
intval($uid)
);