diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/node_flat_sql.erl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/node_flat_sql.erl b/src/node_flat_sql.erl index 05cfa12b3..461c701aa 100644 --- a/src/node_flat_sql.erl +++ b/src/node_flat_sql.erl @@ -897,12 +897,12 @@ select_affiliation_subscriptions(Nidx, GenKey, SubKey) -> GJ = encode_jid(GenKey), SJ = encode_jid(SubKey), case catch ejabberd_sql:sql_query_t( - ?SQL("select jid = %(GJ)s as @(G)b, @(affiliation)s, @(subscriptions)s from " + ?SQL("select @(jid)s, @(affiliation)s, @(subscriptions)s from " " pubsub_state where nodeid=%(Nidx)d and jid in (%(GJ)s, %(SJ)s)")) of {selected, Res} -> lists:foldr( - fun({true, A, S}, {_, Subs}) -> + fun({Jid, A, S}, {_, Subs}) when Jid == GJ -> {decode_affiliation(A), Subs ++ decode_subscriptions(S)}; ({_, _, S}, {Aff, Subs}) -> {Aff, Subs ++ decode_subscriptions(S)} |