By ss_door3 on
Clues anyone?
I've just (2011/12/20) upgraded to the current version of Views.
ALL the relations are failing and all are returning errors of the form:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_MYFIELDNAME.nid' in 'on clause'
When I look in the database the table field_data_field_MYFIELDNAME contains a field called MYFIELDNAME_nid but no field called nid.
And the emitted SQL contains a clause that says:
LEFT JOIN {node} node_field_data_field_MYFIELDNAME ON field_data_field_MYFIELDNAME.nid = node_field_data_field_MYFIELDNAME.nid
So the error message is legit.
And this is not just on one field/table. I am finding this on ANY content/type node-reference field I have built or try to build a relation on.
Does anyone have a patch, a suggestion, a clue ???
Thanks for reading.
Comments
=-=
based on the date it looks like you are using the -dev branch which can include new bugs