Index: openacs-4/packages/forums-portlet/www/forums-portlet.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/forums-portlet.tcl,v diff -u -r1.16.2.1 -r1.16.2.2 --- openacs-4/packages/forums-portlet/www/forums-portlet.tcl 1 May 2008 01:45:52 -0000 1.16.2.1 +++ openacs-4/packages/forums-portlet/www/forums-portlet.tcl 15 May 2008 12:56:53 -0000 1.16.2.2 @@ -37,8 +37,8 @@ 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 WHERE + forums_reading_info_user.forum_id=forums_forums.forum_id AND forums_reading_info_user.user_id=:user_id),0) as count_unread } } else {