Error 1146 on creating VM product detail item menu

Started by tanolalano, January 18, 2015, 22:21:39 PM

Previous topic - Next topic

tanolalano

I get this error when creating a VM product detail Item menu
Table 'db.xxxxx_virtuemart_products_' doesn't exist SQL=SELECT p.`virtuemart_product_id` FROM `xxxxx_virtuemart_products` as p INNER JOIN `xxxxx_virtuemart_products_` as l using (`virtuemart_product_id`) group by p.`virtuemart_product_id` ORDER BY `p`.virtuemart_product_id DESC

It seem that there is an underscore at the end of the table, maybe this the problem?
Any thought?
Regards

My configuration:
J!3.3.6
VM 3.0.3
Php 5.4.31
Mysql 5.5.5
arancebio.it - Organic red Oranges from Sicily

GJC Web Design

Interesting -- the xxxxx_virtuemart_products_  should be I assume the lang table xxxxx_virtuemart_products_en_gb etc

products model file

$joinedTables[] = ' INNER JOIN `#__virtuemart_products_' . VmConfig::$vmlang . '` as l using (`virtuemart_product_id`)';

have ypu set a language or try checking VmConfig::$vmlang

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

tanolalano

I set on VM conf>shop 2 language (Italian and English)
arancebio.it - Organic red Oranges from Sicily

GJC Web Design

#3
Yes - can confirm on J3/VM3.0.3 - you must be the first VM3 user to try and set a product menu!!!!   :)

VmConfig::$vmlang is empty when accessed from this view

This is I assume a bug - reported to Max
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

tanolalano

Quote from: GJC Web Design on January 18, 2015, 23:01:05 PM
Yes - can confirm on J3/VM3.0.3 - you must be the first VM3 user to try and set a product menu!!!!   :)
I'm the first!!  :o
Thank you GJC for quick response

arancebio.it - Organic red Oranges from Sicily