You have not wrapped your tables in {}. This is a MAJOR no no. Because of this, nodehierarchy breaks Domain Access that looks for {table_name} and tries to replace it with {domain_2_table_name}. If anyone is having this issue with Domain Access, please replace the following on line 972 in nodehierarchy.module:

  $query = "
       SELECT nh_menu_links.* 
         FROM node node
    LEFT JOIN nodehierarchy_menu_links nodehierarchy_menu_links ON node.nid = nodehierarchy_menu_links.nid 
    LEFT JOIN menu_links nh_menu_links ON nodehierarchy_menu_links.mlid = nh_menu_links.mlid 
    LEFT JOIN nodehierarchy_menu_links nh_parent ON nh_menu_links.plid = nh_parent.mlid 
        WHERE (nh_parent.nid = %d) 
     ORDER BY nh_menu_links.weight ASC";

With:

  $query = "
       SELECT nh_menu_links.* 
         FROM {node} {node}
    LEFT JOIN {nodehierarchy_menu_links} nodehierarchy_menu_links ON node.nid = nodehierarchy_menu_links.nid 
    LEFT JOIN {menu_links} nh_menu_links ON nodehierarchy_menu_links.mlid = nh_menu_links.mlid 
    LEFT JOIN {nodehierarchy_menu_links} nh_parent ON nh_menu_links.plid = nh_parent.mlid 
        WHERE (nh_parent.nid = %d) 
     ORDER BY nh_menu_links.weight ASC";

Comments

markhalliwell’s picture

Status: Reviewed & tested by the community » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.