VM and dutch languagepack error

[Rolandos]

Hello,

I'm using VM2.0 and Joomla 1.7.3. It works fine together without any problems until I install the dutch languagepack for Joomla 1.7.3. I'll get the following error on all elements of VM (category, latest products, etc.)

Code: [Select]

vmError: vmTable loadTable 'XXX.zfp0s_virtuemart_vendors_nl_nl' doesn't exist SQL=SELECT `zfp0s_virtuemart_vendors_nl_nl`.* ,`zfp0s_virtuemart_vendors`.* FROM `zfp0s_virtuemart_vendors_nl_nl` JOIN zfp0s_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE zfp0s_virtuemart_vendors_nl_nl.`virtuemart_vendor_id` = "1"
Does someone know what the problem is, when default language is set everything works fine!

Greets Rolandos

[glasya]

Have you installed the virtuemart_aio already?

[Rolandos]

Yes I have installed it, but the error follows with the installation of the translation of the site, not the VM language packs.

[Rolandos]

This topic is the solution to my problem: http://forum.virtuemart.net/index.php?topic=91664.msg317182#msg317182

[VM_Fans]

Look at your database table with phpMyAdmin and search for the tables with a language suffix at the end. I suppose you orginally installed VM2 in english. Therefore you should find the following tables:

m0atm_virtuemart_categories_en_gb
m0atm_virtuemart_manufacturercategories_en_gb
m0atm_virtuemart_manufacturers_en_gb
m0atm_virtuemart_paymentmethods_en_gb
m0atm_virtuemart_products_en_gb
m0atm_virtuemart_shipmentmethods_en_gb
m0atm_virtuemart_vendors_en_gb

If one or more of these tables is missing with the sl_si suffix at the end, export the english table, rename the exported file suffix to sl_si and import it again. When you are done, you should also have the sl_si table versions in your database.

m0atm_virtuemart_categories_nl_nl
m0atm_virtuemart_manufacturercategories_nl_nl
m0atm_virtuemart_manufacturers_nl_nl
m0atm_virtuemart_paymentmethods_nl_nl
m0atm_virtuemart_products_nl_nl
m0atm_virtuemart_shipmentmethods_nl_nl
m0atm_virtuemart_vendors_nl_nl

[goretex34]

I know this post is old, but as I found a simplest way to do it, here it is:

Go to Virtuemart->Configuration: Languages:
Multilingual Shop: [      ]
(add here al the languages you need, after having installed them in your Joomla&Virtuemart system, of course)

After saving, it automatically creates the needed tables in your database