4

views 3 upgrade - Relations - SQL ERROR - Column not found: 1054 Unknown column - HUH ???

http://drupal.org

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.

Read »
Created by aaron 22 weeks 1 day ago
Category: News   Tags:

PSD to Drupal Theme

Drupal Development

Module Development

Get an Estimate

Tags for views 3 upgrade - Relations - SQL ERROR - Column not found: 1054 Unknown column - HUH ???

Recent comments