Closed (duplicate)
Project:
Entity reference
Version:
7.x-1.0-beta3
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
1 Feb 2012 at 13:22 UTC
Updated:
1 Feb 2012 at 13:32 UTC
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 ) ; Array ( [:db_condition_placeholder_0] => 28 [:db_condition_placeholder_1] => gallery [:entity_type] => node ) in EntityReferenceHandler_base->validateReferencableEntities() (line 159 of /home/dwightt1/public_html/drupal7/sites/all/modules/entityreference/handler/base.inc)
Comments
Comment #1
damien tournoud commentedThis is a bug in core. See #1325628: EntityFieldQuery::propertyQuery missing fully qualified column names causes ambiguous column DB error.