I have created a node reference between two content types.

It works without problems when I'm logged in as admin.

When logged in as a "normal" user with the correct permissions I get this after I press save.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'nid' in where clause is ambiguous: SELECT DISTINCT node.nid AS entity_id, node.vid AS revision_id, node.type AS bundle, :entity_type AS entity_type FROM {node} node INNER JOIN {node_access} na ON na.nid = node.nid WHERE (nid IN (:db_condition_placeholder_0, :db_condition_placeholder_1, :db_condition_placeholder_2)) AND (type IN (:db_condition_placeholder_3)) AND(( (na.gid = :db_condition_placeholder_4) AND (na.realm = :db_condition_placeholder_5) )OR( (na.gid = :db_condition_placeholder_6) AND (na.realm = :db_condition_placeholder_7) )OR( (na.gid = :db_condition_placeholder_8) AND (na.realm = :db_condition_placeholder_9) )OR( (na.gid = :db_condition_placeholder_10) AND (na.realm = :db_condition_placeholder_11) ))AND (na.grant_view >= :db_condition_placeholder_12) ; Array ( [:db_condition_placeholder_0] => 51265 [:db_condition_placeholder_1] => 238376 [:db_condition_placeholder_2] => 51425 [:db_condition_placeholder_3] => release [:db_condition_placeholder_4] => 0 [:db_condition_placeholder_5] => all [:db_condition_placeholder_6] => 2 [:db_condition_placeholder_7] => forum_access [:db_condition_placeholder_8] => 4 [:db_condition_placeholder_9] => forum_access [:db_condition_placeholder_10] => 5 [:db_condition_placeholder_11] => forum_access [:db_condition_placeholder_12] => 1 [:entity_type] => node ) in EntityFieldQuery->execute() (line 1136 of /includes/entity.inc).

Comments

damien tournoud’s picture

Category: bug » support

Which type of access control module are you using? Looks like an issue there.

madeby’s picture

Category: support » bug

Can be related to this error:
http://drupal.org/node/1309704

Also, it can be caused by the forum access module.

madeby’s picture