News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VM3.0.2: Product info disappeared when site language changed, what's wrong?

Started by hhtmp88, December 24, 2014, 07:27:22 AM

Previous topic - Next topic

hhtmp88

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.
JMY(晉明夷)
http://mfyoga.org -- Mindfulness Yoga Association 靜觀瑜伽協會
http://yogajm.com -- YogaJM 晉明瑜伽
http://jinmy.me -- JMY 晉明日誌
http://jm3ime.com -- JinMing 3-Key Chinese Input Method 晉明三鍵輸入法