Debug:
'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'field_data_field_etykieta_co.nid\' in \'on clause\''
in views_plugin_query_default->execute() (line 1386 from /sites/all/modules/views/plugins/views_plugin_query_default.inc).

where field_etykieta_co is a node reference field.

The same was when using fresh dev version from yesterday and today's dev version.

In the Views screen, the error occurs once I set a relationship to this reference field.

Comments

AndrzejG’s picture

AndrzejG commented

Also caching Views got worse.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed

Please update nodereference.

AndrzejG’s picture

AndrzejG commented

I updated references to newest dev version from 2011-Oct-10.
Error still exists, however, in Views screen now I have a message that displaying a list of relationships require a plug-in controlling displaying of rows, and this plug-in is improper.

Moreover, In Views, Format section, options are lacking for display mode (fields, display suite etc.). I checked that it occurs when (new) option of the field language is checked, and it is checked by default. Should not!

AndrzejG’s picture

AndrzejG commented

Sorry, #3 was caused by cache. After flush, all is OK.

larsdesigns’s picture

larsdesigns commented
Status: Fixed » Needs work

The message is persistent after clearing cache.

onegenius’s picture

onegenius commented

Error very serious.

Updating the reference module to dev version works.

dawehner’s picture

dawehner
Primary language German
commented

So in general this seems to be solved for many people by updating references or some other references implementations

If this doesn't help please read http://drupal.org/node/571990 to give detailed reports.

merlinofchaos’s picture

merlinofchaos commented
Status: Needs work » Postponed (maintainer needs more info)

This appears to be #1275096: Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ...

In this case, fixing a bug in Views seems to have revealed a bug in references

This kind of thing is inevitable, unfortunately.

larsdesigns: Please read and understand the descriptions of the Status values before changing them. You picked a status value that is actually counterproductive here.

dawehner’s picture

dawehner
Primary language German
commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

Let's mark this as duplicate of #1345132: SQLSTATE[42S22] error after updating views
This is exactly the same problem.

ilrecidivo’s picture

ilrecidivo commented
Version: 7.x-3.0-rc3 » 7.x-3.1
Assigned: Unassigned » ilrecidivo
Category: bug » support
Priority: Major » Normal

Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ...
Risolto!
Aggiornare Views 7.x-3.1 + References 7.x-2.0