From fc7e782ba56a456fc7aca840d679e530dce70544 Mon Sep 17 00:00:00 2001 From: friendica Date: Wed, 25 Jun 2014 20:32:24 -0700 Subject: sql error --- mod/group.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mod/group.php') diff --git a/mod/group.php b/mod/group.php index 15e4ff2a3..d9bbec78b 100644 --- a/mod/group.php +++ b/mod/group.php @@ -117,7 +117,7 @@ function group_content(&$a) { check_form_security_token_ForbiddenOnErr('group_member_change', 't'); - $r = q("SELECT abook_xchan from abook where abook_xchan = '%s' and abook_channel = %d and not (xchan_flags & %d) and not (abook_flags & %d) and not (abook_flags & %d) limit 1", + $r = q("SELECT abook_xchan from abook left join xchan on abook_xchan = xchan_hash where abook_xchan = '%s' and abook_channel = %d and not (xchan_flags & %d) and not (abook_flags & %d) and not (abook_flags & %d) limit 1", dbesc(argv(2)), intval(local_user()), intval(XCHAN_FLAGS_DELETED), -- cgit v1.2.3