Project:Node Hierarchy
Version:6.x-1.1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

When trying to create a CCK content type within the OG and having node hierarchy enabled, I get this message as a user, but not as the superuser/admin.

is this an issue with OG or with Node Hierarchy, or is it a setting/permission that needs to be enabled?

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT * FROM node n, nodehierarchy h INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'book_access') OR (na.gid = 5 AND na.realm = 'book_access') OR (na.gid = 0 AND na.realm = 'og_public') OR (na.gid = 10 AND na.realm = 'og_subscriber'))) AND ( h.nid = n.nid AND h.parent = 0 AND n.type IN ('new_job_bbc','story') )ORDER BY h.order_by ASC in /Library/WebServer/Documents/drupal/sites/default/modules/nodehierarchy/nodehierarchy.module on line 985.

Comments

#1

I believe this is a bug in nodehierarchy that appears whenever you have a module installed that uses the node access features in drupal (in your case OG fits the bill). I'll try to figure out what's happening and post a fix as soon as I can.

R

#2

great, thanks! I will look forward to a fix.

#3

Status:active» fixed

Fixed now in dev. Thanks again.

#4

just confirming that commit (http://drupal.org/cvs?commit=158530) fixed the same problem for D5 branch. Thanks for the great work! Now.. if only something could be done about #271112: Menu order changing when nodes are edited for D5 soon :-\

#5

Status:fixed» closed (fixed)

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

nobody click here