When I use relations in view with node linked from Reference module (Node refererence). Views is broken with error something like 

Invalid column field_data_field_ref_logo.rid doen't exists

In rc1 works good, in rc3 broken, in current dev (20. November 2011) broken also.

rc3 version is not possible to use on production, because is failed working with node referenced relations in views.

Comments

dawehner’s picture

dawehner
Primary language German
commented

Sorry this issue was reported multiple times.
To fix it either search in the issue queue or update to the latest dev of the references module.

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Fixed

Update status.

cl00bie’s picture

cl00bie commented

I am up to the latest level of references, and this bug has just presented itself since I upgraded to the latest version of Views. It appears to be ignoring my table prefix cd_ on the SQL table reference.

dawehner’s picture

dawehner
Primary language German
commented

Okay what is rid? Maybe the reference is produced by another module.

cl00bie’s picture

cl00bie commented

I don't believe the "rid" part of it is important. My invalid column is field_data_field_cigar.nid (node id). This is a standard column in all node definitions. However, I do not have a table named field_data_field_cigar. I do have one named cd_field_data_field_cigar (with my designated table prefix).

I back leveled the version to rc1 (which corrected the problem) until this is fixed.

dawehner’s picture

dawehner
Primary language German
commented

Well which module does provide the rid? What kind of reference is this?

cl00bie’s picture

cl00bie commented

I can't tell you. That was used by the original poster. I can tell you my problem involves the standard nid. Should I issue a new bug report for my problem? I piggybacked on this one because it seemed like the same problem.

stano.lacko’s picture

stano.lacko commented

I was looking on page and used modules, try current dev versions of References and Views, but problem still exists. But I found that there is used module Viewfield, I'll check it's new version

stano.lacko’s picture

stano.lacko commented

Nor, when there are no Node reference, with Viewfield is views working.
So every one view with node reference crash also in preview mode in Views UI.

dawehner’s picture

dawehner
Primary language German
commented

If you have updated to the current version of references module take care that you cleared the cache.

stano.lacko’s picture

stano.lacko commented
Status: Fixed » Closed (fixed)

Thanks, with dev version of References RC3 works as previous versions.