I have a content type that is referencing views. As user1 it all works fine, but as any other role I get the following error.

user warning: Unknown column 'n.nid' in 'on clause' query: SELECT name, position FROM viewreference 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 = 0 AND na.realm = 'og_public') OR (na.gid = 28 AND na.realm = 'og_admin') OR (na.gid = 65 AND na.realm = 'og_subscriber'))) AND ( view_id = '48') in /home/umwdtlto/public_html/teachumw/modules/viewreference/viewreference.module on line 165.

All the roles have access to all the views, so I'm not sure what else to do. Any help is much appreciated.

Thanks,
Patrick

Comments

patrickmj’s picture

patrickmj commented

Could this be caused by something amiss with the CCK Content Access module?

patrickmj’s picture

patrickmj commented

More tinkering showed that when I granted a role permission to Administer Nodes, the problem went away. I saw another thread that suggested that Drupal 6.3 should fix at least some of these issues, but I'm in 6.3 now, and it's still going.

Any suggestions, workarounds?

Thanks,
Patrick

danielb’s picture

danielb commented

Sorry about the delay here, CCK has changed significantly since I wrote this module. I am going to set up a site to work all of this out.

danielb’s picture

danielb commented
Status: Active » Closed (duplicate)

dupe of http://drupal.org/node/279841