Today the following message was thrown when attempting to view a 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] => de [:db_condition_placeholder_2] => und ) in advanced_forum_forum_load() (Zeile 142 von /var/www/html/cm7/sites/all/modules/advanced_forum/includes/core-overrides.inc).

Unfortunately I have no idea which of recent updates of my site is causing this error. The site is updated to Drupal 7.12 and all other modules are up-to-date as well.

Comments

Michelle’s picture

Title: Integrity constraint violation: 1052 Column 'status' » Check if code needs changing for Integrity constraint violation: 1052 Column 'status' error
Category: bug » task

I was about to mark this a duplicate of #1437932: Multilingual select 7.x-1.4 module cause PDOException on drupal forum but then it occurred to me that AF literally copies core code in many places where hooking in wasn't possible and it may be that this isn't coming from the actual core issue but rather the same issue in our copy of core's code. So adjusting this issue as a note that this needs to be checked.

Michelle

Michelle’s picture

Category: task » support
Status: Active » Closed (works as designed)

Actually, scratch that. I should have read that issue closely before commenting. The issue isn't actually in forum at all but rather in i18n, so there's nothing to fix in AF, either.

Michelle

GStegemann’s picture

Shall I forward this issue to i18n then?

Michelle’s picture

It's already there.