<div class="gmail_quote">On Sun, Feb 28, 2010 at 3:11 AM, Dick Middleton <span dir="ltr"><<a href="mailto:dick@fouter.net">dick@fouter.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi,<br>
<br>
I've just installed advanced_blog. It seems to do the right thing when<br>
user is admin but when user is a user it gives the following error:<br>
<br>
<quote><br>
user warning: Unknown column 'n.nid' in 'on clause' query: SELECT<br>
node.nid, node.created FROM node INNER JOIN node_access na ON na.nid =<br>
n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all')<br>
OR (na.gid = 4 AND na.realm = 'content_access_author') OR (na.gid = 2<br>
AND na.realm = 'content_access_rid') OR (na.gid = 3 AND na.realm =<br>
'content_access_rid') OR (na.gid = 5 AND na.realm =<br>
'content_access_rid') OR (na.gid = 2 AND na.realm = 'forum_access') OR<br>
(na.gid = 3 AND na.realm = 'forum_access') OR (na.gid = 5 AND na.realm =<br>
'forum_access'))) AND ( node.type = 'blog' AND node.status = 1 AND<br>
node.uid = 4 )ORDER By node.created DESC in<br>
/var/www/qdcc-real/sites/all/modules/advanced_blog/advanced_blog.module<br>
on line 390.<br>
</quote><br>
<br>
Curiously when I look at line 390 in advanced_blog.module it doesn't<br>
look like that at all. It looks like:<br>
<br>
<quote><br>
$query = "SELECT node.nid, node.created FROM {node} WHERE node.type =<br>
'blog' AND node.status = 1 AND node.uid = " . $account->uid . " ORDER By<br>
node.created DESC";<br>
$result = db_query(db_rewrite_sql($query));<br>
</quote><br>
<br>
I'm a bit perplexed by this; I can't find a query similar to the quoted<br>
error query in the advanced_blog.module.<br>
<br>
It seems to be related to the advanced_blog:navigation block as when<br>
that is not used the error goes away.<br>
<br>
I was hoping somebody could help me understand what is going on here.<br>
<br>
Dick<br>
<br>
--<br>
Dick Middleton<br>
<a href="mailto:dick@fouter.net">dick@fouter.net</a><br>
PGP Key ID: 0x9F9434FD<br>
<font color="#888888">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></blockquote></div><br><a href="http://drupal.org/node/712568">http://drupal.org/node/712568</a><br clear="all"><br>-- <br>Nilesh Govindarajan<br>Site & Server Administrator<br><a href="http://www.itech7.com">www.itech7.com</a><br>
<br>