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.
Comments
Comment #0.0
TLTHades CreditAttribution: TLTHades commentedAdd Bags message
Comment #0.1
TLTHades CreditAttribution: TLTHades commentedSorry for the screenshots. The module is partially Russified.
Comment #1
jthorson CreditAttribution: jthorson commentedTLTHades,
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?
Comment #2
TLTHades CreditAttribution: TLTHades commentedThank 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.
Comment #2.0
TLTHades CreditAttribution: TLTHades commentedblockquote