News:

Support the VirtueMart project and become a member

Main Menu

Problem with virtuemart

Started by danielll, April 14, 2016, 15:45:02 PM

Previous topic - Next topic

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?
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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



GJC Web Design

config looks fine to me

is #__virtuemart_products_en_gb really not there?

If not try making it
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

2dmaster

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

Milbo

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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

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

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


with

$d = array_diff($active_langs,$oldLangs);
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

ptrouw

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