forum.module D7.12 PDO Exception probably related to addTag('node_access')

What node access modules do you have enabled?

Edited by mistake in the comment.

The add tag node access tells your node access modules to rewrite the query and invoke their access limitations. Without the add tag, you won't get expected access controls. I suspect the issue is with the rewriting as the join on tid isn't done by core. Please disable acl and content access and report back.

I am also having this problem. I have similar modules enabled (Content Access, ACL, i18n) on D7.12 (Didn't have this issues on D7.10). Will try disabling different modules and report back. Saw this over in the Internationalization issues and thought they might be related - http://drupal.org/node/1429962

see also #1431452: Tests for 'status' in where clause is ambiguous for the fix to the status issue

can you add this to the end of node_query_node_access_alter function

drupal_set_message((string)$query);

and paste the output here

Drupal 7.12 when visiting my site http://mysite.com/forum

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous: SELECT f.tid AS tid, COUNT(n.nid) AS topic_count, SUM(ncs.comment_count) AS comment_count FROM {node} n INNER JOIN {node_comment_statistics} ncs ON n.nid = ncs.nid INNER JOIN {forum} f ON n.vid = f.vid INNER JOIN {node} node ON f.tid = node.tid WHERE (status = :db_condition_placeholder_0) AND (n.language IN (:db_condition_placeholder_1, :db_condition_placeholder_2)) GROUP BY tid; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => vi [:db_condition_placeholder_2] => und ) trong advanced_forum_forum_load() (dòng 142 của /var/www/clients/client1/web29/web/sites/all/modules/advanced_forum/includes/core-overrides.inc).

DONT USE THIS see #18
I just did it for testing prouposes, this is not a solution to the problem also see #23

I receive the same error

PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column node.tid does not exist LINE 6: INNER JOIN node node ON f.tid = node.tid ^: SELECT f.tid AS tid, COUNT(n.nid) AS topic_count, SUM(ncs.comment_count) AS comment_count FROM {node} n INNER JOIN {node_comment_statistics} ncs ON n.nid = ncs.nid INNER JOIN {forum} f ON n.vid = f.vid INNER JOIN {node} node ON f.tid = node.tid WHERE (node.status = :db_condition_placeholder_0) AND (n.language IN (:db_condition_placeholder_1, :db_condition_placeholder_2)) GROUP BY f.tid; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => es [:db_condition_placeholder_2] => und ) en forum_forum_load() (line 779 of modules/forum/forum.module).

and surpas it doing the following:

alter table node rename column tnid to tid;

and in the file forum.module change the lines:

776 ->condition('status', 1)
776 ->condition('node.status', 1) // This is the new one
777 ->groupBy('tid')
777 ->groupBy('f.tid') // This is the new one

I am sure this is not the right way, because it "fix" forum but breaks all the site, the problem is that the JOIN is being doing with "tid" in the "forum module", but in "node" table this column does not exist.

Regards,

DON'T DO THE "FIX":
alter table node rename column tnid to tid;
The node.tnid and forum.tid columns have a different purpose.

I think the problem is that one of function/module/code inside the Drupal 7.12 (I dont know yet which one and why) is adding automatically :
INNER JOIN {node} node ON f.tid = node.tid
to the select clause if we're trying to fetch the f.tid field from the inner joined table (forum).

Just to reiterate DO NOT USE THE FIX mentioned at #17.
tnid is for the node translation set
tid is for taxonomy terms

this is not the correct fix, the issue with with node_access rewriting the query and adding in the node table again (it's already in the query) as per comments at #18.

Can you grep your code base for functions implementing hook_query_node_access_alter other than node_query_node_access_alter.
The default node_query_node_access_alter would not alter the query as shown at #15 - it would be joining against the node_access table so I am hoping it's another contrib module that's implementing hook_query_node_access_alter and struggling.

fergusong is right. The problem is in the i18n_select.module.
Anybody interested should follow: http://drupal.org/node/1437932

Yeeha, we've traced it.
Can everyone affected by this issue confirm they have i18n_select installed?
Marking this as fixed - bot will close it in a couple of weeks - if you aren't using i18n_select then please reopen.