By melanie0118 on

I'm pretty new to all this... but I've been putting content up on our company's site.
I've created a bookpage and image gallery for one particular username to be able to access when signed in. It's not working though. Under "shari" I can see the story (with the link to the image gallery), but when I try to get to the gallery, I get this:

Unknown column 'n.nid' in 'on clause' query: SELECT DISTINCT(n.nid) FROM drupal_term_node t INNER JOIN drupal_node_access na ON na.nid = n.nid INNER JOIN drupal_node n ON t.nid=n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'term_access') OR (na.gid = 8 AND na.realm = 'term_access'))) AND n.status=1 AND n.type='image' AND t.tid=28 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 9 in /home/elitenet/public_html/includes/database.mysql.inc on line 124.

I have NO idea what this means or how to fix it. I've looked under the category permissions and it SHOULD allow for it - as I'm not getting a "page not found" or "permision denied" message. I DO need to keep taxonomy)access enabled though, so everything's not all open to the public

Help Anyone?

Comments

rhuff’s picture

rhuff commented

Do you have organic groups enabled? I turned it on last night on a site that I am developing, and began to see a similar error on my front page.

rivena’s picture

rivena commented

http://drupal.org/node/69108

Apparently it works for her now.

Anisa.

-----------------------------------------------------------
Kindness builds stronger bonds than necessity.

www.animecards.org - 16,000 card scans and counting!
-----------------------------------------------------------

melanie0118’s picture

melanie0118 commented

only if I don't want to keep anything private...

and I do.

:(

melanie0118’s picture

melanie0118 commented

Of course, I don't even know where I'd go to look - there is no "organic groups" under Modules though

(I'm not the one who set the site up - and I can't get to the lady who did)

rivena’s picture

rivena commented

Then you don't have Organic Groups.

This is apparently a problem with node access modules...

It looks very similar to this error:
http://drupal.org/node/51850

This was for Drupal 4.6x, though. What version of Drupal do you have? Does the readme or install file for Taxonomy Access say anything?

Anisa.

-----------------------------------------------------------
Kindness builds stronger bonds than necessity.

www.animecards.org - 16,000 card scans and counting!
-----------------------------------------------------------

melanie0118’s picture

melanie0118 commented

...unless i'm logged in as admin -

the pictures themselves are still there (if I make a link to the tid/# or manually type it into the browser) but the thumbnail indexes are gone. This is a HUGE problem for us - and I really don't want to go make new pages with links to inside the image galleries themselves.

rcolt’s picture

rcolt commented

I get the following error for non-authenticated users:
you may see the problem by going to www.rodriguezforcongress.com/gallery and click on any of the galleries.

user error: Unknown column 'n.nid' in 'on clause'
SELECT COUNT(*) FROM term_node t
INNER JOIN node_access na ON na.nid = n.nid
INNER JOIN node n ON t.nid=n.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid)
IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0'))
AND n.status=1 AND n.type='image' AND t.tid=8

in /home/.leiden/election4/rodriguezforcongress.com/includes/database.mysql.inc on line 66.

user error: Unknown column 'n.nid' in 'on clause'
SELECT DISTINCT(n.nid) FROM term_node t
INNER JOIN node_access na ON na.nid = n.nid
INNER JOIN node n ON t.nid=n.nid WHERE (na.grant_view = 1 AND CONCAT(na.realm, na.gid)
IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0'))
AND n.status=1 AND n.type='image' AND t.tid=8
ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 6

HELP!

rcolt - intense student of drupal / CivicCRM worining to help elect Democrat Robert Rodriguez to Congress