Index: openacs-4/packages/forums/lib/forums/forums-chunk.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/forums-chunk.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/forums/lib/forums/forums-chunk.tcl	4 Jun 2007 12:23:34 -0000	1.8
+++ openacs-4/packages/forums/lib/forums/forums-chunk.tcl	12 Jun 2007 07:18:10 -0000	1.9
@@ -21,8 +21,11 @@
 set useReadingInfo [forum::use_ReadingInfo_p]
 if { $useReadingInfo } {
     set unread_or_new_query {
-	approved_thread_count-COALESCE((SELECT forums_reading_info_user.threads_read WHERE
-		forums_reading_info_user.forum_id=forums_forums_enabled.forum_id AND forums_reading_info_user.user_id=:user_id),0)
+	approved_thread_count-COALESCE(
+				       (SELECT forums_reading_info_user.threads_read 
+					FROM forums_reading_info_user, forums_forums_enabled
+					WHERE forums_reading_info_user.forum_id=forums_forums_enabled.forum_id 
+					AND forums_reading_info_user.user_id=:user_id),0)
 	as count_unread
     }
 } else {