Nodeaccess + Advanced blog = error

hayworth - June 14, 2009 - 22:21
Project:Nodeaccess
Version:6.x-1.3-beta1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

I have a Blog with Advanced blog module.

I would like to hide in my blog some nodes to anonymous user, but I like to see this nodes when I am authenticated like administrator.

I installed Nodeaccess module:

When I am authenticated like administrator user everything works fine.

If I have a node marked in “Grant” to view, edit and delete only by the administrator when I log out, and I am an anonymous user, if I go to “nameuser's blog” I get the error
---
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT node.nid, node.created FROM node 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 = 1 AND na.realm = 'nodeaccess_rid') OR (na.gid = 0 AND na.realm = 'nodeaccess_uid') OR (na.gid = 0 AND na.realm = 'nodeaccess_author'))) AND ( node.type = 'blog' AND node.status = 1 AND node.uid = 1 )ORDER By node.created DESC in /home/xxxxxx/drupal1.xxxxxx.net/html/sites/all/modules/advanced_blog/advanced_blog.module on line 390.
---

and the scheme of Advanced Blog:

2009
June (3)
May (5)
April (1)

disappear, it is not there. If I deactivate the module Nodeaccess everything works again.

 
 

Drupal is a registered trademark of Dries Buytaert.