Language issues VM: VirtueMart is not installed or any ....

hi there,

after a long weekend of tryouts with eshop/builtin VM.

- got the shop up and running, with custom fields, even got a smooth run with the Dutch translation of VM

then.... installing the dutch overal language for joomla, i get the following eorrors:

- the new products/populair items modules don't work anymore on the front page. "Error: No articles to display"
-within the modules, the error is displayed: "VirtueMart is not installed or any VirtueMart categories are available"
(Gavick forum says to have all the (product)categories in the installed language, which i did).

the overall layout VM gives this error:


vmError: vmTable loadTable 'db048246_gala.r8fve_virtuemart_vendors_nl_nl' doesn't exist SQL=SELECT `r8fve_virtuemart_vendors_nl_nl`.* ,`r8fve_virtuemart_vendors`.* FROM `r8fve_virtuemart_vendors_nl_nl` JOIN r8fve_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE r8fve_virtuemart_vendors_nl_nl.`virtuemart_vendor_id` = "1"
vmError: exeSortSearchListQuery Table 'db048246_gala.r8fve_virtuemart_products_nl_nl' doesn't exist SQL=SELECT * FROM `r8fve_virtuemart_products_nl_nl` as l JOIN `r8fve_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `r8fve_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `r8fve_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `r8fve_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND p.`product_in_stock`>"0" AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) AND p.`product_special`="1" ) group by p.`virtuemart_product_id`ORDER BY RAND()ASC LIMIT 0, 5
vmError: exeSortSearchListQuery Table 'db048246_gala.r8fve_virtuemart_products_nl_nl' doesn't exist SQL=SELECT * FROM `r8fve_virtuemart_products_nl_nl` as l JOIN `r8fve_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `r8fve_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `r8fve_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `r8fve_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND p.`product_in_stock`>"0" AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY product_sales DESC LIMIT 0, 5

I understand while adding this we are on a weekend break, i really hope to get some decent help this coming week through pm or other assistance. currrently have 2 subscriptions running at Gavick.

regards
emel





now, while installing

vmError: vmTable loadTable 'db048246_gala.r8fve_virtuemart_vendors_nl_nl' doesn't exist SQL=SELECT `r8fve_virtuemart_vendors_nl_nl`.* ,`r8fve_virtuemart_vendors`.* FROM `r8fve_virtuemart_vendors_nl_nl` JOIN r8fve_virtuemart_vendors using (`virtuemart_vendor_id`) WHERE r8fve_virtuemart_vendors_nl_nl.`virtuemart_vendor_id` = "1"
vmError: exeSortSearchListQuery Table 'db048246_gala.r8fve_virtuemart_products_nl_nl' doesn't exist SQL=SELECT * FROM `r8fve_virtuemart_products_nl_nl` as l JOIN `r8fve_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `r8fve_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `r8fve_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `r8fve_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND p.`product_in_stock`>"0" AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL ) AND p.`product_special`="1" ) group by p.`virtuemart_product_id`ORDER BY RAND()ASC LIMIT 0, 5
vmError: exeSortSearchListQuery Table 'db048246_gala.r8fve_virtuemart_products_nl_nl' doesn't exist SQL=SELECT * FROM `r8fve_virtuemart_products_nl_nl` as l JOIN `r8fve_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `r8fve_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` LEFT JOIN `r8fve_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `r8fve_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `r8fve_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND p.`product_in_stock`>"0" AND (s.`virtuemart_shoppergroup_id`= "2" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY product_sales DESC LIMIT 0, 5

Hi there:

I have the same issue here: silla.ferozo.com.

Please, give us instructions to fix this issue. In my case, the language is Spanish.

Regards.

you need to replace the language of the joomla site, besides this you need to install the appropriate language files for VM. final step is to (re)build the categories and items in your own language, then the modules look good again.

still struggling with the custom fields though within this template, a big mess.

Reinstalling VM component can hep,
I hoped that in VM3 it will be better but it's still crappy software, brrr.