Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
MichelleI 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
Comment #2
MichelleActually, 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
Comment #3
GStegemann CreditAttribution: GStegemann commentedShall I forward this issue to i18n then?
Comment #4
MichelleIt's already there.