I installed the 5.0 tarball and started building a site map. I have a package that I mount many subsites on and there appears to be a change in subsite in 5.0 that only allows mounting subsites directly on other subsite packages. In the after mount callback there is a query that finds the subsite group and constrains the new subsite to only allow members that are in the parent subsite.

         select m.group_id as supersite_group_id, p.instance_name as supersite_name
         from application_groups m, apm_packages p, site_nodes s1, site_nodes s2
         where s1.node_id = :node_id
           and s2.node_id = s1.parent_id
           and p.package_id = s2.object_id
           and m.package_id = s2.object_id

Since this query only looks at the parent node it does not return a row if the parent is not a subsite. Is this change intentional or should the query find the closest subsite?

so it should be

set subsite_id [site_node_closest_ancestor_package "acs-subsite"]

db_1row g {
select m.group_id as supersite_group_id, p.instance_name as supersite_name
from application_groups m
where m.package_id = :subsite_id
}

If so I'll patch my machine and try it.