From f8c8827b2416ad6d8b0a1beb4a58db66032a7508 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sun, 13 Sep 2009 14:12:07 +0000
Subject: - Patch #554164 by mfb: fixed bug with forum topic counts and added
 tests.

---
 modules/forum/forum.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/forum/forum.module')

diff --git a/modules/forum/forum.module b/modules/forum/forum.module
index e61d47be7..b88e04928 100644
--- a/modules/forum/forum.module
+++ b/modules/forum/forum.module
@@ -623,7 +623,7 @@ function forum_get_forums($tid = 0) {
   if (count($_forums)) {
     $query = db_select('node', 'n');
     $query->join('node_comment_statistics', 'ncs', 'n.nid = ncs.nid');
-    $query->join('forum', 'f', 'f.vid = f.vid');
+    $query->join('forum', 'f', 'n.vid = f.vid');
     $query->addExpression('COUNT(n.nid)', 'topic_count');
     $query->addExpression('SUM(ncs.comment_count)', 'comment_count');
     $counts = $query
-- 
cgit v1.2.3