Hello,

I have this error when I go to the forum page as admin :

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] => fr [:db_condition_placeholder_2] => und ) dans advanced_forum_forum_load() (ligne 154 in sites/all/modules/advanced_forum/includes/core-overrides.inc).

and this error as anonymous :

PDOException : SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous: SELECT DISTINCT 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 INNER JOIN {node_access} na ON na.nid = n.nid INNER JOIN {node_access} na_2 ON na_2.nid = node.nid WHERE (status = :db_condition_placeholder_0) AND (n.language IN (:db_condition_placeholder_1, :db_condition_placeholder_2)) AND(( (na.gid = :db_condition_placeholder_3) AND (na.realm = :db_condition_placeholder_4) )OR( (na.gid = :db_condition_placeholder_5) AND (na.realm = :db_condition_placeholder_6) )OR( (na.gid = :db_condition_placeholder_7) AND (na.realm = :db_condition_placeholder_8) )OR( (na.gid = :db_condition_placeholder_9) AND (na.realm = :db_condition_placeholder_10) )OR( (na.gid = :db_condition_placeholder_11) AND (na.realm = :db_condition_placeholder_12) ))AND (na.grant_view >= :db_condition_placeholder_13) AND(( (na_2.gid = :db_condition_placeholder_14) AND (na_2.realm = :db_condition_placeholder_15) )OR( (na_2.gid = :db_condition_placeholder_16) AND (na_2.realm = :db_condition_placeholder_17) )OR( (na_2.gid = :db_condition_placeholder_18) AND (na_2.realm = :db_condition_placeholder_19) )OR( (na_2.gid = :db_condition_placeholder_20) AND (na_2.realm = :db_condition_placeholder_21) )OR( (na_2.gid = :db_condition_placeholder_22) AND (na_2.realm = :db_condition_placeholder_23) ))AND (na_2.grant_view >= :db_condition_placeholder_24) GROUP BY tid; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => fr [:db_condition_placeholder_2] => und [:db_condition_placeholder_3] => 0 [:db_condition_placeholder_4] => all [:db_condition_placeholder_5] => 0 [:db_condition_placeholder_6] => content_access_author [:db_condition_placeholder_7] => 1 [:db_condition_placeholder_8] => content_access_rid [:db_condition_placeholder_9] => 0 [:db_condition_placeholder_10] => domain_site [:db_condition_placeholder_11] => 0 [:db_condition_placeholder_12] => flag_friend [:db_condition_placeholder_13] => 1 [:db_condition_placeholder_14] => 0 [:db_condition_placeholder_15] => all [:db_condition_placeholder_16] => 0 [:db_condition_placeholder_17] => content_access_author [:db_condition_placeholder_18] => 1 [:db_condition_placeholder_19] => content_access_rid [:db_condition_placeholder_20] => 0 [:db_condition_placeholder_21] => domain_site [:db_condition_placeholder_22] => 0 [:db_condition_placeholder_23] => flag_friend [:db_condition_placeholder_24] => 1 ) dans advanced_forum_forum_load() (ligne 154 in all/modules/advanced_forum/includes/core-overrides.inc).

Comments

troky’s picture

Status: Active » Postponed (maintainer needs more info)

Can you try with AF disabled and report back?

michee.lengronne’s picture

With AF disabled and its database dropped :

for admin :

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] => fr [:db_condition_placeholder_2] => und ) dans forum_forum_load() (ligne 779 dans modules/forum/forum.module).

and for anonymous :

PDOException : SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'status' in where clause is ambiguous: SELECT DISTINCT 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 INNER JOIN {node_access} na ON na.nid = n.nid INNER JOIN {node_access} na_2 ON na_2.nid = node.nid WHERE (status = :db_condition_placeholder_0) AND (n.language IN (:db_condition_placeholder_1, :db_condition_placeholder_2)) AND(( (na.gid = :db_condition_placeholder_3) AND (na.realm = :db_condition_placeholder_4) )OR( (na.gid = :db_condition_placeholder_5) AND (na.realm = :db_condition_placeholder_6) )OR( (na.gid = :db_condition_placeholder_7) AND (na.realm = :db_condition_placeholder_8) )OR( (na.gid = :db_condition_placeholder_9) AND (na.realm = :db_condition_placeholder_10) )OR( (na.gid = :db_condition_placeholder_11) AND (na.realm = :db_condition_placeholder_12) ))AND (na.grant_view >= :db_condition_placeholder_13) AND(( (na_2.gid = :db_condition_placeholder_14) AND (na_2.realm = :db_condition_placeholder_15) )OR( (na_2.gid = :db_condition_placeholder_16) AND (na_2.realm = :db_condition_placeholder_17) )OR( (na_2.gid = :db_condition_placeholder_18) AND (na_2.realm = :db_condition_placeholder_19) )OR( (na_2.gid = :db_condition_placeholder_20) AND (na_2.realm = :db_condition_placeholder_21) )OR( (na_2.gid = :db_condition_placeholder_22) AND (na_2.realm = :db_condition_placeholder_23) ))AND (na_2.grant_view >= :db_condition_placeholder_24) GROUP BY tid; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => fr [:db_condition_placeholder_2] => und [:db_condition_placeholder_3] => 0 [:db_condition_placeholder_4] => all [:db_condition_placeholder_5] => 0 [:db_condition_placeholder_6] => content_access_author [:db_condition_placeholder_7] => 1 [:db_condition_placeholder_8] => content_access_rid [:db_condition_placeholder_9] => 0 [:db_condition_placeholder_10] => domain_site [:db_condition_placeholder_11] => 0 [:db_condition_placeholder_12] => flag_friend [:db_condition_placeholder_13] => 1 [:db_condition_placeholder_14] => 0 [:db_condition_placeholder_15] => all [:db_condition_placeholder_16] => 0 [:db_condition_placeholder_17] => content_access_author [:db_condition_placeholder_18] => 1 [:db_condition_placeholder_19] => content_access_rid [:db_condition_placeholder_20] => 0 [:db_condition_placeholder_21] => domain_site [:db_condition_placeholder_22] => 0 [:db_condition_placeholder_23] => flag_friend [:db_condition_placeholder_24] => 1 ) dans forum_forum_load() (ligne 779 dans modules/forum/forum.module).

So, it seems to be a problem with the core forum itself.

troky’s picture

Category: bug » support

http://drupal.org/node/1437932

Try to install the latest dev version of Internationalization module

michee.lengronne’s picture

It works. Thanks a lot.

Michelle’s picture

Status: Postponed (maintainer needs more info) » Fixed

Thanks for reporting back.

Status: Fixed » Closed (fixed)

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