I AM USING:
1. Gavick Template
2. Joomla 2.5
3. PHP 5.3
4 VM: 2.0.20b
vmError: getNeighborProducts Unknown column 'category_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `les86_virtuemart_products` as `p` JOIN `les86_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `les86_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `les86_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 12 and `slug` < "mokoros" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY category_name DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'category_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `les86_virtuemart_products` as `p` JOIN `les86_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `les86_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `les86_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 12 and `slug` > "mokoros" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY category_name ASC LIMIT 0,1
See http://forum.virtuemart.net/index.php?topic=114063