Hi,
I've just installed advanced_blog. It seems to do the right thing when user is admin but when user is a user it gives the following error:
<quote> 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 = 4 AND na.realm = 'content_access_author') OR (na.gid = 2 AND na.realm = 'content_access_rid') OR (na.gid = 3 AND na.realm = 'content_access_rid') OR (na.gid = 5 AND na.realm = 'content_access_rid') OR (na.gid = 2 AND na.realm = 'forum_access') OR (na.gid = 3 AND na.realm = 'forum_access') OR (na.gid = 5 AND na.realm = 'forum_access'))) AND ( node.type = 'blog' AND node.status = 1 AND node.uid = 4 )ORDER By node.created DESC in /var/www/qdcc-real/sites/all/modules/advanced_blog/advanced_blog.module on line 390. </quote>
Curiously when I look at line 390 in advanced_blog.module it doesn't look like that at all. It looks like:
<quote> $query = "SELECT node.nid, node.created FROM {node} WHERE node.type = 'blog' AND node.status = 1 AND node.uid = " . $account->uid . " ORDER By node.created DESC"; $result = db_query(db_rewrite_sql($query)); </quote>
I'm a bit perplexed by this; I can't find a query similar to the quoted error query in the advanced_blog.module.
It seems to be related to the advanced_blog:navigation block as when that is not used the error goes away.
I was hoping somebody could help me understand what is going on here.
Dick