Index: openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql,v diff -u -r1.12 -r1.12.2.1 --- openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql 2 Apr 2013 11:05:18 -0000 1.12 +++ openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql 17 Sep 2013 22:24:40 -0000 1.12.2.1 @@ -84,7 +84,7 @@ and n.tree_sortkey between n2.tree_sortkey and tree_right(n2.tree_sortkey) and (n.parent_id is null or n.parent_id in ([join $expand ", "]))) site_map on site_map.object_id = p.package_id - $where_limit + $where_limit order by url Index: openacs-4/packages/acs-subsite/www/admin/site-map/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/index.tcl,v diff -u -r1.27.4.6 -r1.27.4.7 --- openacs-4/packages/acs-subsite/www/admin/site-map/index.tcl 9 Sep 2013 17:25:31 -0000 1.27.4.6 +++ openacs-4/packages/acs-subsite/www/admin/site-map/index.tcl 17 Sep 2013 22:24:40 -0000 1.27.4.7 @@ -50,9 +50,14 @@ set user_id [ad_conn user_id] set subsite_number [db_string count_subsites "select count(*) from apm_packages where package_key = 'acs-subsite'"] -if {$subsite_number > 100} { +# +# Not sure, what the intentions was to omit all(!) subsites if there +# are more than 100. e.g. http://openacs.org/bugtracker/openacs/bug?bug_number=3174 +# Subsite-omitting is deactivated for the time being. +# +if {0 && $subsite_number > 100} { set too_many_subsites_p 1 - set where_limit "where apm_packages.package_key <> 'acs-subsite'" + set where_limit "where p.package_key <> 'acs-subsite'" } else { set too_many_subsites_p 0 set where_limit ""