Author Topic: VM and dutch languagepack error  (Read 4789 times)

Rolandos

  • Beginner
  • *
  • Posts: 9
VM and dutch languagepack error
« 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

glasya

  • Beginner
  • *
  • Posts: 48
Re: VM and dutch languagepack error
« Reply #1 on: January 19, 2012, 11:56:21 am »
Have you installed the virtuemart_aio already?

Rolandos

  • Beginner
  • *
  • Posts: 9
Re: VM and dutch languagepack error
« Reply #2 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.

Rolandos

  • Beginner
  • *
  • Posts: 9
Re: VM and dutch languagepack error
« Reply #3 on: January 20, 2012, 01:15:20 am »

VM_Fans

  • Full Member
  • ***
  • Posts: 251
Re: VM and dutch languagepack error
« Reply #4 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

goretex34

  • Beginner
  • *
  • Posts: 37
    • Zeesl web design · diseño web Zeesl
Re: VM and dutch languagepack error
« Reply #5 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
------------------------------------
www.Zeesl.com  @Zeesl
www.chartconsulting.net @chartcon
@goretex34