Index: openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql 7 Aug 2017 23:48:12 -0000 1.6 +++ openacs-4/packages/forums-portlet/www/forums-portlet-postgresql.xql 22 May 2018 14:32:10 -0000 1.7 @@ -3,26 +3,6 @@ postgresql7.1 - - - select forums_forums.package_id, - acs_object__name(apm_package__parent_id(forums_forums.package_id)) as parent_name, - (select site_node__url(site_nodes.node_id) - from site_nodes - where site_nodes.object_id = forums_forums.package_id) as url, - forums_forums.forum_id, - forums_forums.name, - $unread_or_new_query - from forums_forums_enabled forums_forums, - acs_objects - where acs_objects.object_id = forums_forums.forum_id and - forums_forums.package_id in ([join $list_of_package_ids ,]) - $private_data_restriction - order by parent_name, - forums_forums.name - - - and acs_permission__permission_p(forums_forums.package_id, :user_id, 'read_private_data')