Hello, please Im working on my site reachtraining.eu, and today im trying to set a multilingual page by adding another language to my site.. Before virtuemart went well, no problems. But today when I click on virtuemart in administrator, it gives me this:
1146 Table 'ee016700db.#__virtuemart_products_en_gb' doesn't exist SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `#__virtuemart_products` as p INNER JOIN `#__virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `#__virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` WHERE ( p.`virtuemart_vendor_id` = "1" ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering` DESC, `virtuemart_product_id` DESC LIMIT 0, 30
Also the same when I click on "webshop" in my site online at reachtraining.eu...
I dont know what I did wrong and what should I do right now, can u please help me with that? :/
THANKS A LOT FOR HELP!!
#__virtuemart_products_en_gb' doesn't exist
have u deleted the eng language from VM?
Hello, thanks for reply,
No I have not, I just added language to joomla, but not deleting anything, and I was not doing anything to VM for sure :/.
here are screenshots :
https://gyazo.com/faf32c3ec2d2f048ca5279dbd16b99fb
https://gyazo.com/8cad4aa3187658f56710bf5577d09913
config looks fine to me
is #__virtuemart_products_en_gb really not there?
If not try making it
It seems like it has a problem with en language, but im not sure why because in VM configurations it seems like EN is there (I was not adding any language to VM) :/... This is my first time working with VM, so I dont really know what to do, when I click in administrator/VM on almost everything, it gives error such as - 1146 Table 'ee016700db.#__virtuemart_categories_en_gb' doesn't exist SQL=SELECT etc...
so what should I do please? , how can I make #__virtuemart_products_en_gb?
Thanks for answers! really appriciate your help!!
Error: 1146 - Table 'ee016700db.#__virtuemart_manufacturers_en_gb' doesn't exist SQL=SELECT
it is fairly obvious your en lang tables aren't there
I have asked u to check...
if not remake them
just re-install VM again should do it... back up first
Do you have en-GB content language setup properly (not just the language pack)?
I reinstalled it, and it works well right now, thanks guys!.. I just have another problem, when I started to rebuild the virtuemart webshop, I found out that when I go to my website, there are still the old products from old virtuemart, and when in administrator, there are not appearing... what should I do to completely delete those old products when I dont see them in my administrator?
thanks a lot for help!
probably don't have translations
just remove them directly from the DB
need delete all languages, save, set english and save, next tables created
Quote from: GJC Web Design on April 18, 2016, 23:22:15 PM
just re-install VM again should do it... back up first
Storing the config ususally recreates the tables, if not existing. Or using the table updater in the tools and btw, we have a manual and FAQ about that topic http://docs.virtuemart.net/manual/general-concepts/214-multilanguage-and-multlingual.html
http://docs.virtuemart.net/faqs/38-troubleshooting/113-products-vanished.html
I think I found the reason, that tables are not created.
file /administrator/components/com_virtuemart/models/config.php (or just the config model)
replace around line 479
$d = array_diff($oldLangs,$active_langs);
with
$d = array_diff($active_langs,$oldLangs);
Indeed, just added a new languages. Works fine now.