Problem with virtuemart

[danielll]

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!!

[GJC Web Design]

#__virtuemart_products_en_gb' doesn't exist

have u deleted the eng language from VM?

[danielll]

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 :/.

[danielll]

here are screenshots :
https://gyazo.com/faf32c3ec2d2f048ca5279dbd16b99fb
https://gyazo.com/8cad4aa3187658f56710bf5577d09913

[GJC Web Design]

config looks fine to me

is #__virtuemart_products_en_gb really not there?

If not try making it

[danielll]

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!!

[danielll]

Error: 1146 - Table 'ee016700db.#__virtuemart_manufacturers_en_gb' doesn't exist SQL=SELECT

[GJC Web Design]

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

[Ghost]

Do you have en-GB content language setup properly (not just the language pack)?

[danielll]

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!

[GJC Web Design]

probably don't have translations

just remove them directly from the DB

[2dmaster]

need delete all languages, save, set english and save, next tables created

[Milbo]

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

[Milbo]

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

Code Select Expand


$d = array_diff($oldLangs,$active_langs);


with

Code Select Expand


$d = array_diff($active_langs,$oldLangs);


[ptrouw]

Indeed, just added a new languages. Works fine now.