(Solved) Products disappear when change lang!!

[another_reality]

Hello mates,

I was have the following problem on my VM2-Stable with Joomla 1.7 installed.

I have a website with more than 150 products & all of them registered at the VM database. My client wants the main site in other language (Not in UK),  so i download the language pack for VM and Joomla 1.7, i setup it and make it default!! When i went back to VM then the products & categories was disappear. Then i switched on default language, and all come back as it was.

I start looking around to find a solution on this, so i find this solution for them that have not read this thread before installing http://forum.virtuemart.net/index.php?PHPSESSID=1b1935b7d710ea3a72cb474b9740ee91&topic=94183.msg309152

• When i went to configuration i found the MULTILANGUE option and checked both of installed languages.
• Then i went to products and edit. A dropdown with language select appear, i cheked the second lang and change only the alias (If you don't change the alias the product will not be saved).
• Then Save.

But i have to do this process for the next 149 products, and i must change the alias. I don't need that.

Searching the forum i found this thread http://forum.virtuemart.net/index.php?PHPSESSID=1b1935b7d710ea3a72cb474b9740ee91&topic=94183.msg309152 . VM create a separate table for every language that you have installed on your system.

• Login to phpMyAdmin
• Find the table "virtuemart_categories_en_gb" and export it.
• Open the exported .sql file and replace "_en_gb" with your other language prefix
• Delete all the categories from the table "virtuemart_categories_en_gb" from phpMyAdmin
• Import the modified .sql
• Go to VM admin and you will find all categories viewed to your other language

For products - manufacturers - vendors - payments - shipments just make the same steps.

Have a nice day.

[Milbo]

Just because others may also read this thread.

It is a lot easier just to use for the tables the an sql like
"ALTER TABLE `jos_virtuemart_manufacturers_en_gb`  RENAME TO `jos_virtuemart_manufacturers_de_de`;"

of course you must adjust the jos_ to and the language "tags"