I get a warning when I go to http://example.com/blogs/username: user warning: Column 'NID' field list is ambiguous in query: SELECT DISTINCT NID, created FROM node n INNER JOIN ON node_access na.nid na = n . NID WHERE (na.grant_view> = 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid') OR (na.gid = 1 AND na.realm = 'forum_access'))) AND ((n.moderate! = 1)) AND (type = 'blog' AND status <> 0 AND uid = 283) ORDER BY created DESC in / home / policy / public_html / sites / all / modules / advanced_blog / advanced_blog.module on line 333
This warning is not only to site administrators, site administrators seem non-users. What could be the reason?

Comments

Gökhan DAĞ’s picture

Gökhan DAĞ commented

6.x-1.0-beta1 version of the same problems in the module and it seems that the fix is not available.

Shame :(

svendecabooter’s picture

svendecabooter
he/him
Primary language Dutch
Location Gent
commented
Assigned: Gökhan DAĞ » Unassigned
Status: Needs review » Active
CobraMP’s picture

CobraMP commented

yep just got it here http://siofan.com/blog/fairy-godmother

Gökhan DAĞ’s picture

Gökhan DAĞ commented

You can get information about improvements in this regard are we?

Respects..

jaypan’s picture

jaypan
Location Victoria, BC
commented

Change line of advanced_blog.module 332 from this:

$query = "SELECT nid, created FROM {node} n WHERE type = 'blog' AND status <> 0 AND uid = %d ORDER BY created DESC";

to this:

$query = "SELECT n.nid, n.created FROM {node} n WHERE n.type = 'blog' AND n.status <> 0 AND n.uid = %d ORDER BY n.created DESC";

svendecabooter’s picture

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

Well spotted.
Fixed in HEAD.

Status: Fixed » Closed (fixed)

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