From fd6590a98761da3a5e8175bfb6ff9884c2f297bb Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Mon, 13 Mar 2006 12:43:01 +0000
Subject: [PATCH] Fix for bug 4875 which was only happening on MySQL 5

---
 mod/forum/lib.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index 0423f70257..5b438fc162 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -1435,9 +1435,9 @@ function forum_get_discussions($forum="0", $forumsort="d.timemodified DESC",
     } else {
         return get_records_sql("SELECT $postdata, d.name, d.timemodified, d.usermodified, d.groupid,
                                    u.firstname, u.lastname, u.email, u.picture $umfields
-                              FROM {$CFG->prefix}forum_posts p,
+                              FROM ({$CFG->prefix}forum_posts p,
                                    {$CFG->prefix}user u,
-                                   {$CFG->prefix}forum_discussions d
+                                   {$CFG->prefix}forum_discussions d)
                                    $umtable
                              WHERE d.forum = '$forum'
                                AND p.discussion = d.id
-- 
2.39.5