VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: hhtmp88 on December 24, 2014, 07:27:22 AM

Title: VM3.0.2: Product info disappeared when site language changed, what's wrong?
Post by: hhtmp88 on December 24, 2014, 07:27:22 AM
My default site Language is Traditional Chinese, when I switch it to English, and click on "products" in the Virtuemart backend, the following error message will be displayed:
====================================================
vmError: exeSortSearchListQuery Table 'yogajm88_mfy.mfy_virtuemart_products_en_gb' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `mfy_virtuemart_products` as p LEFT JOIN `mfy_virtuemart_products_en_gb` as ld using (`virtuemart_product_id`) LEFT JOIN `mfy_virtuemart_products_zh_cn` as l using (`virtuemart_product_id`) LEFT JOIN `mfy_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering` DESC LIMIT 0, 100
===================================================
-> and all the products that I was created disappeared, including those created by VM installation programs,
-> if I switch back to Traditional Chinese, everything goes normal


Are there ways to keep everything working when I switch languages?
-> and let me translate when I see such a necessity to do so.