Can't get it working. Installed it, changed the settings in the reference field and try to add a record.

If field and value are correct - I get following error message.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'nid' in where clause is ambiguous: SELECT node.nid AS entity_id, node.vid AS revision_id, node.type AS bundle, :entity_type AS entity_type FROM {node} node LEFT OUTER JOIN {support_ticket} st ON st.nid = node.nid WHERE (nid IN (:db_condition_placeholder_0)) AND (type IN (:db_condition_placeholder_1)) AND (st.nid IS NULL ) ORDER BY node.title ASC; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => address [:entity_type] => node ) in EntityFieldQuery->execute() (Zeile 1136 von /var/www/mahnportal/http/includes/entity.inc).

Comments

rteuber’s picture

rteuber commented
Priority: Critical » Normal

Ivestigated it a bit mire. It seems there is an compatibility issue with the support module. After unabling the module this module works.

But I need to run both. :-(

Admdebian’s picture

Admdebian commented

I have the same bug. With administrator account I have no problems, but if I try with a normal user, I have the problem.

mshepherd’s picture

mshepherd commented

Just bumping the issue. I'm seeing this also.

As Admdebian reports, with an admin account, it works fine, but with a less priveledged user, I get this error:

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)) AND (type 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) ))AND (na.grant_view >= :db_condition_placeholder_11) ; Array ( [:db_condition_placeholder_0] => 80 [:db_condition_placeholder_1] => get [:db_condition_placeholder_2] => give [:db_condition_placeholder_3] => 0 [:db_condition_placeholder_4] => all [:db_condition_placeholder_5] => 22 [:db_condition_placeholder_6] => content_access_author [:db_condition_placeholder_7] => 2 [:db_condition_placeholder_8] => content_access_rid [:db_condition_placeholder_9] => 6 [:db_condition_placeholder_10] => content_access_rid [:db_condition_placeholder_11] => 1 [:entity_type] => node ) in EntityFieldQuery->execute() (line 1136 of /var/aegir/platforms/drupal-7.12/includes/entity.inc).

mshepherd’s picture

mshepherd commented

A little more digging suggests this is a core issue. Follow this thread for more info: http://drupal.org/node/1325628

damien_vancouver has helpfully supplied a patch and a pre-patched entity.inc file. See http://drupal.org/node/1325628#comment-5570156 The workflow should be that i t will be fixed for Drupal 8 and then backported to Drupal 7.

I'll post back when I've tested this later on.

mshepherd’s picture

mshepherd commented
Title: Fatal Error » SQL error when trying to prepopulate an entity reference field with a non-admin account
Status: Active » Closed (won't fix)

The patch at http://drupal.org/node/1325628#comment-5571342 fixes this issue.

In my opinion, this confirms it as a core issue. I'll therefore, on behalf of the developer, take the liberty of marking this as won't fix.