Drupal 4.6.5

I just did a site to site transfer and only have this one bug.

Before I log in I get the below error and Quotes is not working,

but after I log in it goes away and Quotes works

Can I fix this somehwo?

user error: Unknown column 'n.nid' in 'on clause'
query: SELECT COUNT(*) FROM main_quotes q INNER JOIN main_node_access na ON na.nid = n.nid INNER JOIN main_node n ON n.nid = q.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 q.promote = 1 AND '1' in /home/.needle/user/work.mywebsite.com/includes/database.mysql.inc on line 66.

thanks

Comments

Tweaker’s picture

Tweaker commented
Version: » 4.6.x-1.x-dev
Component: Miscellaneous » Code
Category: support » bug

Ug, I get a nearly identical bug as you. Except I'm using taxonomy_access instead of node_privacy_by_role. If anyone has a fix for this, they'd make my day. I can't figure it out. :(

jhriggs’s picture

jhriggs commented

Is this still a problem with the latest version of all of the modules? It seems to be a problem with with the SQL-rewriting being done by the access modules, but I am not sure. I know users who are successfully using quotes with access modules, though.

jhriggs’s picture

jhriggs commented
Status: Active » Closed (fixed)

No feedback. Closing.