I just updated views from 7.x-3.0-rc1 to 7.x-3.0-rc3 and now I am getting the following error on views that include relationships created by the Node References module (micity is a node reference field).

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_micity.nid' in 'on clause'

Here is the error log message:
User notice:
'Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column \'field_data_field_city.nid\' in \'on clause\''
in views_plugin_query_default->execute() (line 1386 of /home/pace/public_html/imc/sites/all/modules/views/plugins/views_plugin_query_default.inc).

CommentFileSizeAuthor
Screen shot 2011-11-17 at 2.08.34 PM.png166.21 KBflugga

Comments

jhm’s picture

jhm commented

I had exactly the same problem and painstakingly rolled back from a database backup ...

jhm’s picture

jhm commented

check if http://drupal.org/node/1344248 is the solution

flugga’s picture

flugga commented

updating reference does the trick, but I don't like the idea of using a dev version.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed

Update to the current version of the references module or better next time search the issue queue. We got a lot of reports like that.

larsdesigns’s picture

larsdesigns commented

The user notice message is persistent even while running the current version of the references module.

larsdesigns’s picture

larsdesigns commented
Status: Fixed » Needs work

Seems to be a problem with the upgrade path. Perhaps it is related to this patch: http://drupal.org/files/1072860-Fix-for-views_update_nn-functions-in-vie... ?

dawehner’s picture

dawehner
Primary language German
commented
Status: Needs work » Postponed (maintainer needs more info)

@larsdesign
Please post more detailed information about your issue, as for flugga updating references module did the trick.

merlinofchaos’s picture

merlinofchaos commented

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 is not a problem with the upgrade path, per se.

This kind of thing is inevitable, unfortunately. Perhaps we can convince the maintainer of references to put out a new release to help prevent this kind of issue.

larsdesigns: I can only conclude that you have a different error, or you either do not have the current version of references or have not cleared cache.

dawehner’s picture

dawehner
Primary language German
commented

There is an issue in the references module issue queue which suggests to put out a new release #1345374: Add a new release

esmerel’s picture

esmerel commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)
esmerel’s picture

esmerel commented
Issue summary: View changes

proofing edit