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