Hi all!
On the league do not appear related field. The error is:

user warning: Unknown column 'ult_fieldassignments.nid' in 'on clause' query: SELECT node_ult_fieldassignments.nid AS node_ult_fieldassignments_nid, node_ult_fieldassignments.title AS node_ult_fieldassignments_title, node_ult_fieldassignments_node_data_field_ult_numfields.field_ult_numfields_value AS node_ult_fieldassignments_node_data_field_ult_numfields_fiel, node_ult_fieldassignments.type AS node_ult_fieldassignments_type, node_ult_fieldassignments.vid AS node_ult_fieldassignments_vid, node_ult_fieldassignments_node_data_field_ult_numfields.field_ult_fieldcode_value AS node_ult_fieldassignments_node_data_field_ult_numfields_fiel_1, node_ult_fieldassignments_node_data_field_ult_numfields.field_ult_fieldrating_value AS node_ult_fieldassignments_node_data_field_ult_numfields_fiel_2, node_ult_fieldassignments_node_data_field_ult_numfields.field_ult_fieldstatus_value AS node_ult_fieldassignments_node_data_field_ult_numfields_fiel_3 FROM node node LEFT JOIN ult_fieldassignments ult_fieldassignments ON node.nid = ult_fieldassignments.lid LEFT JOIN node node_ult_fieldassignments ON ult_fieldassignments.nid = node_ult_fieldassignments.nid LEFT JOIN node node_ult_fieldassignments_1 ON ult_fieldassignments.nid = node_ult_fieldassignments_1.nid LEFT JOIN content_type_ult_fieldsite node_ult_fieldassignments_node_data_field_ult_numfields ON node_ult_fieldassignments.vid = node_ult_fieldassignments_node_data_field_ult_numfields.vid WHERE node_ult_fieldassignments_1.nid = 4 in /var/www/test/1/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1155.

Sorry for the screenshots. The module is partially Russified.

CommentFileSizeAuthor
2.png59.2 KBTLTHades
1.png40.69 KBTLTHades
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

TLTHades’s picture

Issue summary: View changes

Add Bags message

TLTHades’s picture

Issue summary: View changes

Sorry for the screenshots. The module is partially Russified.

jthorson’s picture

TLTHades,

Strange ... the ult_fieldassignments table columns are 'lid' and 'fid', so there should never be a reference to ult_fieldassignments.nid in that query.

Can you confirm which Views version you are using (6.x-2.x or 6.x-3.x)? If using 6.x-3.x, can you try the 6.x-2.x version and let me know if it addresses the problem?

TLTHades’s picture

Thank you for your response.

I use the Views version 6.x-3.0. In the near future I will try to roll back to version 6.x-2.16 and let you know the results.

TLTHades’s picture

Issue summary: View changes

blockquote