Fix for a bug 4906 in pg 8.4.0

[ndwebbie.git] / lib / NDWeb / Controller / Forum.pm

diff --git a/lib/NDWeb/Controller/Forum.pm b/lib/NDWeb/Controller/Forum.pm
index a2f1cb89952e3021cd59ce63854b9a2cebbe366b..4cca534c3f7e2137cda1f3640dffed7d1edf2d7d 100644 (file)
--- a/lib/NDWeb/Controller/Forum.pm
+++ b/lib/NDWeb/Controller/Forum.pm
@@ -472,7 +472,7 @@ sub findUsers : Private {
 
        my $query = $dbh->prepare(q{SELECT uid,username FROM users
                WHERE uid > 0 AND uid IN (SELECT uid FROM groupmembers)
-               ORDER BY LOWER(username)});
+               ORDER BY username});
        $query->execute;
 
        $c->stash(users => $query->fetchall_arrayref({}) );
@@ -487,8 +487,8 @@ sub findThread : Private {
                FROM forum_boards fb
                        NATURAL JOIN forum_threads ft
                        NATURAL JOIN forum_categories fc
-                       LEFT OUTER JOIN (SELECT * FROM forum_access
-                               WHERE gid IN (SELECT groups($2))
+                       LEFT OUTER JOIN (SELECT fa.* FROM forum_access fa
+                               JOIN (SELECT groups($2) AS gid) g USING (gid)
                        ) fa USING (fbid)
                WHERE ft.ftid = $1 AND (fa.post IS NOT NULL
                        OR ft.ftid IN (SELECT ftid FROM forum_priv_access WHERE uid = $2))