When changing the website language, virtuemart does not work

[JinXter]

Hi all!

As many off you im totally in love with virtuemart,
i still cant believe how easy it is to configure a webshop so quickly!
Everything is working out fine and thanks to the forum im able to costumize to my needs.

There is one thing i cant seem to fix and it has something to do with the language packs.
Im currently running virtuemart 2.0 on a 1.7 joomla installation.
For my purpose i need to have the website en virtuemart working in dutch.

I installed the dutch language pack for joomla
and the 2 dutch language packs for virtuemart.

For some strange reason, when i change the jooma site language, virtuemart stops working
and displaces the following errors on the front:


In the category views:

vmError: vmTable loadTable 'playbiz.bakfo_virtuemart_categories_nl_nl' doesn't exist SQL=SELECT `bakfo_virtuemart_categories_nl_nl`.* ,`bakfo_virtuemart_categories`.* FROM `bakfo_virtuemart_categories_nl_nl` JOIN bakfo_virtuemart_categories using (`virtuemart_category_id`) WHERE bakfo_virtuemart_categories_nl_nl.`virtuemart_category_id` = "2"


vmError: vmTable loadTable 'playbiz.bakfo_virtuemart_categories_nl_nl' doesn't exist SQL=SELECT `bakfo_virtuemart_categories_nl_nl`.* ,`bakfo_virtuemart_categories`.* FROM `bakfo_virtuemart_categories_nl_nl` JOIN bakfo_virtuemart_categories using (`virtuemart_category_id`) WHERE bakfo_virtuemart_categories_nl_nl.`virtuemart_category_id` = "14"

This happens in every category...


In the checkout cart i read the following:

vmError: vmTable loadTable 'playbiz.bakfo_virtuemart_vendors_nl_nl' doesn't exist SQL=SELECT `bakfo_virtuemart_vendors_nl_nl`.* ,`bakfo_virtuemart_vendors`.* FROM `bakfo_virtuemart_vendors_nl_nl` JOIN bakfo_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE bakfo_virtuemart_vendors_nl_nl.`virtuemart_vendor_id` = "1"


Does someone know how i could fix this?

Thanks a bunch!


Michael

[MaHe29]

It looks like you didnt install the langues pack correct.
Because the sqltables that arn't found are made when installing the languespack.
take a look in the database, if the tables doesnt exist, just delete en reinstall the langues packs.
Also you need to create the categories again if you did this before installing the languespack or copy the content to the *_nl tables.

[JinXter]

Hi!

Thanks for the reply,
i understand and think that the language files are installed correctly.
But i did make the categories before the install of the language packs.

If i understand correctly, the articles and categories are attached to 1 language?
so you need to make the articles and categories again for each language?

That seems so much work.

Is there any way for me to copy the categories and articles that i made in english to dutch?
I allready added about 800 products! 

[MaHe29]

I've had the same issue. Your can export the files form the SQL database.
After that ive edited the output in notepad and changed the table names like this
Tabelstructuur voor tabel `(prefix)_virtuemart_categories`to `(prefix)_virtuemart_categories_nl`
Make sure you change al the tables names using the search function and search for  "virtuemart_categories"

[jjk]

See also here: http://forum.virtuemart.net/index.php?topic=95970.msg317893#msg317893

[chiappa]

Thanks for the link!

My solution with VirtueMart 2.0.2 was: Configuration -> Configuration -> Multilingual shop: (select your language here).

Immediate response was:

created table jooml_virtuemart_products_fi_fi
      created table jooml_virtuemart_vendors_fi_fi
      created table jooml_virtuemart_categories_fi_fi
      created table jooml_virtuemart_manufacturers_fi_fi
      created table jooml_virtuemart_manufacturercategories_fi_fi
      created table jooml_virtuemart_paymentmethods_fi_fi
      created table jooml_virtuemart_shipmentmethods_fi_fi
      Configuration Saved

& voila.

[The big]

Hello !

I have a little problem here.
I am using joomla2.5.6 and VM 2.0.8a.  I am trying to make joomla multilingual (English and French).

In the configuration page of VM I got this message:

         
              created table jooml_virtuemart_products_fi_fi
      created table jooml_virtuemart_vendors_fi_fi
      created table jooml_virtuemart_categories_fi_fi
      created table jooml_virtuemart_manufacturers_fi_fi
      created table jooml_virtuemart_manufacturercategories_fi_fi
      created table jooml_virtuemart_paymentmethods_fi_fi
      created table jooml_virtuemart_shipmentmethods_fi_fi
      Configuration Saved

So I assume so far so good ! 

My only trouble is, when I add a new category and chose it be be done in french, once saved, it is turned into English!

Any ideas how to solve this problem, maybe it's something I've done wrong!

Regards

[jjk]

Have a look at the link I posted two posts above yours. 

[ipicado]

Hi, the correct solution is:

1. Go to Components, select VirtueMart
2. Go to Tools, select Update, migration
3. Go to install tables and if necessary update them to click.
4. The tables will be created according to the configured language.

Problem solved!

[sendanor]

Hello,

I tried the last suggestion, updating through tools/migration in the virtuemart backend,

I got this message:

vmdebug self::$_jpConfig->lang nl_nl
vmdebug vmTime: loadConfig db no: 0.00387501716614
vmdebug fwiqe_virtuemart_waitingusers Alter field notify_date oldcolumn Var1:
TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP' ON UPDATE CURRENT_TIMESTAMP
Var2:
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Table updated: Tablename fwiqe_virtuemart_waitingusers dropped: 0 altered: 1 added: 0
Database updated
vmdebug self::$_jpConfig->lang nl_nl
vmdebug vmTime: loadConfig db no: 0.00303101539612

Still no result: the webshop still doesn't show up when setting the language to Dutch. I have virtuemart 2.08e, in a Joomla 2.5.6 environment, the url of the webshop is http://lindamanya.com/index2/index.php/welkom-webwinkel

HELP: I am at complete loss, I would appreciate any help, I am not a big database genius. Thanks in advance anyone/everyone.

[sendanor]

PS: at the moment, I have changed the language setting of my website back to English, in order to be able to add/change other things in the present state of the website/webshop.

[sendanor]

PS2: after migrating through going to the suggested Tools, select Update, migration, I get this errror message:

vmError: forSale Path/Url is not set correct :
vmError: port Products db error Table 'lindama_db02.fwiqe_vm_product' doesn't exist SQL=SELECT *,`p`.product_id as product_id FROM `fwiqe_vm_product` AS `p` LEFT JOIN `fwiqe_vm_product_price` ON `fwiqe_vm_product_price`.`product_id` = `p`.`product_id` LEFT JOIN `fwiqe_vm_product_mf_xref` ON `fwiqe_vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000
vmError: port Products db error SELECT *,`p`.product_id as product_id FROM `#__vm_product` AS `p` LEFT JOIN `#__vm_product_price` ON `#__vm_product_price`.`product_id` = `p`.`product_id` LEFT JOIN `#__vm_product_mf_xref` ON `#__vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000
vmError: port Orders db error Table 'lindama_db02.fwiqe_vm_orders' doesn't exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2`,`o`.order_id FROM `fwiqe_vm_orders` as `o` LEFT OUTER JOIN `fwiqe_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `fwiqe_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL ORDER BY o.order_id LIMIT 0,1000
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2`,`o`.order_id FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL ORDER BY o.order_id LIMIT 0,1000
Info: No Shoppergroup table found for migration
Info: No vm_category table found for migration
Info: Migration: 0 products processed
Info: Migration: 0 orders processed 0 done.

I am still at a complete loss on what to do. HELP, anyone!!!!

[jjk]

Above you said that your are using J2.5.6 and VM2.0.8e. The Migration tools are for upgrading from VM1.x to VM2.x. If you use the Migration tool without having a VM1.x shop, there is nothing to upgrade and you used the wrong tool. (some links about migration are here: http://forum.virtuemart.net/index.php?topic=95513.0

Concering your language problem, follow these guides (you probably missed one or two steps): http://forum.virtuemart.net/index.php?topic=104901.0

[sendanor]

Above you said that your are using J2.5.6 and VM2.0.8e. The Migration tools are for upgrading from VM1.x to VM2.x. If you use the Migration tool without having a VM1.x shop, there is nothing to upgrade and you used the wrong tool. (some links about migration are here: http://forum.virtuemart.net/index.php?topic=95513.0

Concering your language problem, follow these guides (you probably missed one or two steps): http://forum.virtuemart.net/index.php?topic=104901.0

To make  sure I did not miss steps from your suggested links:
I have installed a fresh, blank Joomla 2.5.6 on http://lindamanya.com/index2/; after that I installed both extracted files from the com_virtuemart.2.0.8e_extract_first.zip package on http://dev.virtuemart.net/projects/virtuemart/files. I then installed the NL language pack extracted from the com_virtuemart.2.0.8d_languages_extract_first.zip, also downloaded from  http://dev.virtuemart.net/projects/virtuemart/files. I selected Dutch-NL under the VM configuration tab, selected NL from the 'Multilingual shop' form field and got me a NL box .

AND STILL: both the VM frontend and backend do not appear in Dutch.

NOTE: the migration tools under the VM table tools were completely left alone this time, I did NOT migrate VM tables this time, the only migration prior to the installation of the VM files I did was with the SP upgrade migration tool; this only transferred core files like  articles, core modules like menus,  and media files. So I can confirm that I have NOT migrated files from a VM 1.1.xx version, because on my prior url http://lindamanya.com/index, virtuemart 2.0.8 already functioned under  a Joomla 1.5 environment.

On top of that, my webshop link http://lindamanya.com/index2/nl-NL/webwinkel  shows the nasty error "No Shop Currency defined!". For this problem, I already visited the suggestions on http://forum.virtuemart.net/index.php?topic=97109.0 ; still, like cobzhoare stated, I cannot save the selected currency, however clearly it appears in the form field when selected.

ANY suggestions? I am at my wits end again.

[sendanor]

OK, sequel to the ongoing story again: the currency error problem is solved when having selected currency  and filled in manufacturer and vendor fields under the configuration/shop tab.

Still, both frontend and backend won't appear in dutch.