MDL-1626 mod_forum: Correct SQL syntax when fetching subscriptions
authorAndrew Nicols <andrew@nicols.co.uk>
Tue, 24 Jun 2014 06:48:23 +0000 (14:48 +0800)
committerAndrew Nicols <andrew@nicols.co.uk>
Tue, 24 Jun 2014 06:48:23 +0000 (14:48 +0800)
mod/forum/classes/subscriptions.php

index 60349e0..de4253b 100644 (file)
@@ -436,7 +436,7 @@ class subscriptions {
                         WHERE u.id IN (
                             SELECT u2.id FROM
                             {user} u2
-                            JOIN ($esql) je ON je.id = u.id
+                            JOIN ($esql) je ON je.id = u2.id
                             LEFT JOIN {forum_subscriptions} s ON s.userid = u2.id
                             LEFT JOIN {forum_discussion_subs} ds ON ds.userid = u2.id
                             WHERE