Closed (fixed)
Project:
Node Hierarchy
Version:
6.x-2.x-dev
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 May 2010 at 23:42 UTC
Updated:
31 May 2010 at 16:30 UTC
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
Comment #1
markhalliwell