I have a directional relation called "allows bookings for" between two entities (location -> night).

In views, I create two "relationships". The first is location -> relation. The second is relation -> night. Instantly I see an SQL Error:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'title' in field list is ambiguous

Comments

Chris Gillis’s picture

Chris Gillis commented
Status: Active » Closed (duplicate)

Turns out I had some old fields in my sort criteria. This is actually a duplicate of http://drupal.org/node/1309142.