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
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
I set on VM conf>shop 2 language (Italian and English)
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
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