When I went to http://test.friendsofhope.us/photos/image/22 I got the following error messages in the browser,

* user warning: Unknown table 'n' in on clause query: SELECT fid FROM x_image INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( pid =24 )ORDER BY fid DESC in /home/httpd/friendsofhope_test/sites/all/modules/photos/photos.module on line 491.
* user warning: Unknown table 'n' in on clause query: SELECT fid FROM x_image INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all'))) AND ( pid =24 )ORDER BY fid DESC in /home/httpd/friendsofhope_test/sites/all/modules/photos/photos.module on line 491.

I'm running Drupal 6.4 on Linux with MySQL. I've seen these messages on a few other occasions. --Scott

Comments

eastcn’s picture

eastcn commented

This is the node access module lead to mistakes.
photos.module on line 491 , Please edit to:

$result = db_query($sql, $pid);
kennedyjs’s picture

kennedyjs commented
Title: * user warning: Unknown table 'n' in on clause query: SELECT fid FROM x_image INNER JOIN node_access... » Re: * user warning: Unknown table 'n' in on clause query: SELECT fid FROM x_image INNER JOIN node_access...

Thank you. That fixed the problem. --Scott

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Active » Fixed
Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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