The site is http://popkrazy.com/

When viewing a blog by a specific user like http://popkrazy.com/blog/5 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 = 'workflow_access') OR (na.gid = 0 AND na.realm = 'workflow_access_owner'))) AND ( node.type = 'blog' AND node.status = 1 AND node.uid = 5 )ORDER By node.created DESC in /var/www/vhosts/popkrazy.com/httpdocs/sites/all/modules/advanced_blog/advanced_blog.module on line 390.

appears at the top of the page for anonymous users only. This appears for blog pages for all users.

Comments

zim2411’s picture

zim2411 commented
Priority: Normal » Minor

Nevermind, fixed.

The block Advanced Blog: navigation was causing issues with the workflow module. I have no use for it right now, so I am just disabling the block.

Max_Headroom’s picture

Max_Headroom commented
Priority: Minor » Normal

It is not a particular module causing the problem.
The query needs to be fixed.
replace node with n.

$query = "SELECT n.nid, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 AND n.uid = " . $account->uid . " ORDER By n.created DESC";
svendecabooter’s picture

svendecabooter
he/him
Primary language Dutch
Location Gent
commented
Assigned: zim2411 » Unassigned
Status: Active » Fixed

This was fixed in the latest updates to the module

Status: Fixed » Closed (fixed)

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