VM and languagepack

Hello,

First of all, thanks for the wonderfull template!

My problem occurs when I install the dutch languagepack, vm gives the following error. (browse-our-store page)

vmError: vmTable loadTable 'm1_2d9c14e3.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 is working fine!

Greets Rolandos

Well something is wrong with your language pack, zfp0s_virtuemart_vendors_nl_nl is for example just zfp0s_virtuemart_vendors so it adds _nl_nl and it should not do that.

Strange, cause in the back-end (admin) the translations works good for Joomla 1.7.3 and Virtuemart 2.0. It breaks only in the front-end of the Virtuemart modules.

On the Dutch translation site they said after installing the language pack there must be a table called: xxxxx_virtuemart_vendors_nl_nl.

Greets Rolandos

Maybe you did not install language file properly. I am wondering why the table xxxxx_virtuemart_vendors_nl_nl is not created after VM language installation?

I looked for the missing tables with a language suffix at the end. I've found these tables:

zfp0s_virtuemart_categories_en_gb
zfp0s_virtuemart_manufacturercategories_en_gb
zfp0s_virtuemart_manufacturers_en_gb
zfp0s_virtuemart_paymentmethods_en_gb
zfp0s_virtuemart_products_en_gb
zfp0s_virtuemart_shipmentmethods_en_gb
zfp0s_virtuemart_vendors_en_gb

I exported the the english tables and rename them to _nl_nl and and imported it again. That work's fine for me

In PHPmyadmin change table name

SQL

RENAME TABLE wa89g_virtuemart_manufacturercategories_en_gb TO wa89g_virtuemart_manufacturercategories_mk_mk(_mk_mk is for Macedonian language)

GO

change all table:
wa89g_virtuemart_categories_en_gb
wa89g_virtuemart_manufacturercategories_en_gb
wa89g_virtuemart_manufacturers_en_gb
wa89g_virtuemart_paymentmethods_en_gb
wa89g_virtuemart_products_en_gb
wa89g_virtuemart_shipmentmethods_en_gb
wa89g_virtuemart_vendors_en_gb