From 62a6a11cc02a9d4f1125180708cf71d1a2ebdf9e Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Tue, 25 Aug 2009 10:01:10 +0200 Subject: [PATCH] Fix for a bug 4906 in pg 8.4.0 --- lib/NDWeb/Controller/Forum.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/NDWeb/Controller/Forum.pm b/lib/NDWeb/Controller/Forum.pm index caeeb1c..4cca534 100644 --- a/lib/NDWeb/Controller/Forum.pm +++ b/lib/NDWeb/Controller/Forum.pm @@ -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)) -- 2.39.2