the filter, can't work with node:language term.
if i check "english", all node are listed, if i check the secondary language, have no listed data, but i have translated nodes.

here is the pictures:

my language settings are:

    default, with no id: english
    secondary, with "magyar" mark: hungarian

Comments

merlinofchaos’s picture

merlinofchaos commented

Can you paste the full query that it generates in both cases for me?

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Postponed (maintainer needs more info)
yang_yi_cn’s picture

yang_yi_cn commented

I have the same problem. My view doesn't involve with any languages. I wrote an English page and published it, the view works at en.demosite.com/view_abc , but fr.demosite.com/view_abc is empty.
However, when I translated the page to French, the fr.demosite.com/view_abc works.

I just wonder will it be better to show English content if there's no translation found?

eaposztrof’s picture

eaposztrof
Primary language Hungarian
Location Székelyföld
commented

sorry.. just now i can work with that again.. the problem still there..
here is the query:

Query

SELECT node.nid AS nid,
term_data.name AS term_data_name
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
WHERE (node.status <> 0 OR node.uid = ***CURRENT_USER*** or ***ADMINISTER_NODES*** = 1) AND (node.type in ('link')) AND (node.language in ('***CURRENT_LANGUAGE***'))
ORDER BY term_data_name ASC

pasqualle’s picture

pasqualle
Location 🇭🇺 Budapest
commented

@eaposztrof, @yang_yi_cn:
do you use the i18n module? if yes then try the latest dev release of i18n module, or try to disable the i18n module..

this could be a problem: #272432: Patch to prevent query rewriting for views

sun’s picture

sun
Primary language German
Location Karlsruhe
commented
Status: Postponed (maintainer needs more info) » Closed (duplicate)

Marking as duplicate of #272432: Patch to prevent query rewriting for views