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
See https://forum.virtuemart.net/index.php?topic=114063
http://forum.virtuemart.net/index.php?topic=114523