Query with term reference not executed on view page

hehe, indeed.

So I was more or less able to isolate the issue now: when I add a relationship to the view which is a node reference field inside the taxonomy - the view stops showing in live mode. The only thing that is set in the view is for it to show one fields: taxonomy term name.

This is the query executed without the relationship in preview mode:

SELECT taxonomy_term_data.name AS taxonomy_term_data_name, taxonomy_term_data.vid AS taxonomy_term_data_vid, taxonomy_term_data.tid AS tid, taxonomy_vocabulary.machine_name AS taxonomy_vocabulary_machine_name
FROM 
{taxonomy_term_data} taxonomy_term_data
LEFT JOIN {taxonomy_vocabulary} taxonomy_vocabulary ON taxonomy_term_data.vid = taxonomy_vocabulary.vid

This is what gets done with it (in preview mode again):

SELECT taxonomy_term_data.name AS taxonomy_term_data_name, taxonomy_term_data.vid AS taxonomy_term_data_vid, taxonomy_term_data.tid AS tid, taxonomy_vocabulary.machine_name AS taxonomy_vocabulary_machine_name
FROM 
{taxonomy_term_data} taxonomy_term_data
LEFT JOIN {field_data_field_work_area_term_node} field_data_field_work_area_term_node ON taxonomy_term_data.tid = field_data_field_work_area_term_node.entity_id AND (field_data_field_work_area_term_node.entity_type = 'taxonomy_term' AND field_data_field_work_area_term_node.deleted = '0')
LEFT JOIN {node} node_field_data_field_work_area_term_node ON field_data_field_work_area_term_node.field_work_area_term_node_nid = node_field_data_field_work_area_term_node.nid
LEFT JOIN {taxonomy_vocabulary} taxonomy_vocabulary ON taxonomy_term_data.vid = taxonomy_vocabulary.vid

i18n is also enabled on the site and for the taxonomy (set to the 2nd, "Localize" option for the vocabulary that has terms with that relationship) Disabling translation options for the terms in the vocabulary didnt seem to have any effect.

Let me know if you need more :)

anything else I can add to help? :(

Hm, same happens when I add a term reference field to my content type, and then add that as a relationship in my node-based view.. so basically doing it the opposite way around now, but same issue.

to be more precise, the view shows correctly when the relationship is added, but no fields are using that relationship.. as soon as I add one field nothing is shown on the end page.. hmm

Isolated the above bug to be caused by the "Select nodes by language" setting of the Translation Select module - when that is enabled, the view doesn't show any results.

The content type in question is set to "Set current language as default for new content." and the nodes themselves have all either "English" or "French" selected. The referenced taxonomy terms come from a vocabulary that has "Localize. Terms are common for all languages, but their name and description may be localized." set.

Please let me know if you need any further details. (Most details come from op and comment 4)

Thanks

I actually have the 'views' tag set in the module options, so as you said it shouldn't be rewriting these queries.. but somehow it still is (or so it would seem).

(Switching back to bug report as it's not what you thought it was it seems).

I dunno, how do I check? From what I can tell the query is not executed at all on the actual page at all (judging from the list of queries from devel) - just in preview mode inside the view.. it's all very weird really. Let me know what I can do to provide more info.

Cheers

thanks! did the trick for me :)