Installing and upgrading help

Hi Max,

Adding those brackets seems to work.  Thanks for the research.  The file to modify is mod/forum/lib.php.  Search for 'forum_get_discussions' to get to the function.   The lines to modify are  about the 56th and  58th.  I've copied this section of the function below to show where I put the brackets.

    //TODO: there must be a nice way to do this that keeps both postgres and mysql 3.2x happy but I can't find it right now.
    if ($CFG->dbtype == 'postgres7') {
        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_discussions d
                              JOIN {$CFG->prefix}forum_posts p ON p.discussion = d.id
                              JOIN {$CFG->prefix}user u ON p.userid = u.id
                                   $umtable
                             WHERE d.forum = '$forum'
                               AND p.parent = 0
                                   $groupselect $userselect
                          ORDER BY $forumsort $limit");
    } else {
        return get_records_sql("SELECT $postdata, d.name, d.timemodified, d.usermodified, d.groupid,
                                   u.firstname, u.lastname, u.email, u.picture $umfields
bracket here ->       FROM ({$CFG->prefix}forum_discussions d,
                                   {$CFG->prefix}forum_posts p,
bracket here ->           {$CFG->prefix}user u) 
                                   $umtable
                             WHERE d.forum = '$forum'
                               AND p.discussion = d.id
                               AND p.parent = 0
                               AND p.userid = u.id $groupselect $userselect
                          ORDER BY $forumsort $limit");
    }