Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
When i change to RTL the term field in view page only show (..any..)in the translated language after select (..any..) then will load the English and all term . any idea ...
Your description is not clear at all, sorry. Please try to write better English, or provide a screencast. You're using Mac OS X, so you can use http://jingproject.com/ (free).
I'm building multilingual website and i use taxonomy for type of cars, and for searching a car i used HS in a view, when i load the page in English it load all term in the HS field with no problem, but when i go to other language like kurdish or arabic when the page load only show ANY and SELECT not all terms, when i select ANY then it load all the other term, u can see it in the screen cast : http://www.screencast.com/t/A0TskybG
I found the problem, when i added the term, I added them manually to the (term_data) and (term_hierarchy) in the database, but when i added it, somehow (language) filed in (term_data) table took (en) as a value, so when load the other language it didn't find any term because SQL statement say (t.language ='ku' OR t.language ='' OR t.language IS NULL) it couldn't find any of (ku) or (ar) so it return empty, so i change all language value to NULL, it fix.
the English page SQL is :
(SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE (t.language ='en' OR t.language ='' OR t.language IS NULL) AND ( t.vid = 1 )ORDER BY weight, name)
Comments
Comment #1
wim leersYour description is not clear at all, sorry. Please try to write better English, or provide a screencast. You're using Mac OS X, so you can use http://jingproject.com/ (free).
Comment #2
Rasti commentedHi
I'm building multilingual website and i use taxonomy for type of cars, and for searching a car i used HS in a view, when i load the page in English it load all term in the HS field with no problem, but when i go to other language like kurdish or arabic when the page load only show ANY and SELECT not all terms, when i select ANY then it load all the other term, u can see it in the screen cast :
http://www.screencast.com/t/A0TskybG
thanx.. sorry for bad english.
Comment #3
Rasti commentedhi ....
any solution for my problem???
or do u need more information.??
thanks..
Comment #4
wim leersI haven't had the time to look into this. I'll try to do that this weekend.
Comment #5
Rasti commentedHi..
I found the problem, when i added the term, I added them manually to the (term_data) and (term_hierarchy) in the database, but when i added it, somehow (language) filed in (term_data) table took (en) as a value, so when load the other language it didn't find any term because SQL statement say (t.language ='ku' OR t.language ='' OR t.language IS NULL) it couldn't find any of (ku) or (ar) so it return empty, so i change all language value to NULL, it fix.
the English page SQL is :
(SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE (t.language ='en' OR t.language ='' OR t.language IS NULL) AND ( t.vid = 1 )ORDER BY weight, name)
thanks....
Comment #6
wim leersAha! Well, you should definitely not be inserting them directly into the DB, unless you're 300% certain about what you're doing :)
Comment #7
Rasti commentedYea your right but adding 2350 item is not easy and arrange with there parent.
and i found how it took English and not empty text .
when you select in vocabulary translation mode
"Set language to vocabulary. The vocabulary will have a global language and it will only show up for pages in that language."
and you choose on of the language, it will change the language in database, but if you want go back and choose :
"None. No multilingual options for this vocabulary." in the vocabulary translation mode.
then the language field in the database doesn't change, remain as the last language has been selected, maybe this is a bug.
anyway thanks ...