News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

error virtuemat 2.0.20b

Started by jar, April 20, 2013, 18:32:58 PM

Previous topic - Next topic

jar

Please I have a problem about  virtuemat 2.0.20b and I don't get resorver.
I need informartion about the problem.



vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `yb8g1_virtuemart_products` as `p` JOIN `yb8g1_virtuemart_products_es_es` as `l` using (`virtuemart_product_id`) JOIN `yb8g1_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `yb8g1_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 116 and `slug` < "caja-laminas-vforce3" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'product_price' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `yb8g1_virtuemart_products` as `p` JOIN `yb8g1_virtuemart_products_es_es` as `l` using (`virtuemart_product_id`) JOIN `yb8g1_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `yb8g1_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 116 and `slug` > "caja-laminas-vforce3" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY product_price ASC LIMIT 0,1

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum