VirtueMart Forum

VirtueMart 1.1.x [ Old version - no longer supported ] => Translation / Languages VM 1.1 => Topic started by: Rolandos on January 18, 2012, 23:57:38 pm

Title: VM and dutch languagepack error
Post by: Rolandos on January 18, 2012, 23:57:38 pm
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
Title: Re: VM and dutch languagepack error
Post by: glasya on January 19, 2012, 11:56:21 am
Have you installed the virtuemart_aio already?
Title: Re: VM and dutch languagepack error
Post by: Rolandos on January 19, 2012, 12:12:09 pm
Yes I have installed it, but the error follows with the installation of the translation of the site, not the VM language packs.
Title: Re: VM and dutch languagepack error
Post by: Rolandos on January 20, 2012, 01:15:20 am
This topic is the solution to my problem: http://forum.virtuemart.net/index.php?topic=91664.msg317182#msg317182
Title: Re: VM and dutch languagepack error
Post by: VM_Fans on January 22, 2012, 04:23:09 am
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
Title: Re: VM and dutch languagepack error
Post by: goretex34 on May 21, 2013, 13:35:09 pm
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