Index: openacs-4/packages/sloan-bboard/www/subscriptions.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/sloan-bboard/www/subscriptions.tcl,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/sloan-bboard/www/subscriptions.tcl 18 Feb 2002 13:21:06 -0000 1.2 +++ openacs-4/packages/sloan-bboard/www/subscriptions.tcl 25 Feb 2002 20:44:11 -0000 1.3 @@ -30,7 +30,7 @@ # categories db_multirow category_subs get_category_subs { - select bcs.category_id, short_name as name, forum_id + select bcs.category_id, bc.short_name as name, bf.forum_id from bboard_category_subscribers bcs, bboard_categories bc, bboard_forums bf where bcs.category_id = bc.category_id and bcs.subscriber_id = :user_id Index: openacs-4/packages/sloan-bboard/www/subscriptions.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/sloan-bboard/www/subscriptions.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/sloan-bboard/www/subscriptions.xql 18 Feb 2002 13:21:06 -0000 1.2 +++ openacs-4/packages/sloan-bboard/www/subscriptions.xql 25 Feb 2002 20:44:11 -0000 1.3 @@ -18,7 +18,7 @@ - select bcs.category_id, short_name as name, forum_id + select bcs.category_id, bc.short_name as name, bf.forum_id from bboard_category_subscribers bcs, bboard_categories bc, bboard_forums bf where bcs.category_id = bc.category_id and bcs.subscriber_id = :user_id