Jump to:
| Project: | Photoblog |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Annonymous users get this:
user warning: Unknown column 'u.nid' in 'on clause' query: SELECT DISTINCT(u.uid), u.name FROM users u INNER JOIN node n ON u.uid = n.uid INNER JOIN term_node tn ON n.nid = tn.nid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN node_access na ON na.nid = u.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( n.type = 'image' AND n.status = 1 AND td.vid = 2 ) ORDER BY u.name in /home/user/dir/site/includes/database.mysql.inc on line 172.
im using the following modules:
pathauto
internationalization
image
moxie
og
privatemsg
views
buddylist
installed by the readme, created a photoblog then changed from "global" to "per-user" logged out and got that message, all other settings are defaults.
What could it be?
Comments
#1
update: actually, everyone that is not the site administrator gets that message, btw sorry to hear you are abandoning the project, i think its a very cool module!
#2
Im having a error very similar
user warning: Unknown column 'u.nid' in 'on clause' query: SELECT DISTINCT(u.uid), u.name FROM Port_drusers u INNER JOIN Port_drnode n ON u.uid = n.uid INNER JOIN Port_drterm_node tn ON n.nid = tn.nid INNER JOIN Port_drterm_data td ON td.tid = tn.tid INNER JOIN Port_drnode_access na ON na.nid = u.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'og_public'))) AND ( n.type = 'image' AND n.status = 1 AND td.vid = 3 ) ORDER BY u.name in /home/user/public_html/DRUPAL/includes/database.mysql.inc on line 172.
Any ideas?
#3
resetting title so that it makes sense when reading the issue query.
#4
what title? sorry I'm new on drupal