VM Search

[roman5527]

Hi ,

i have problem with vm search .


i see error :

vmError: exeSortSearchListQuery Unknown column 'p.product_name' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `kr0ul_virtuemart_products_en_gb` as l JOIN `kr0ul_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `kr0ul_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `kr0ul_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `kr0ul_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `kr0ul_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `kr0ul_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `kr0ul_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ( p.`published`="1" AND `pc`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "2" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY p.product_name ASC LIMIT 0, 9

can you help me ? thanks

PS: i have Joomla 2.5.16 and Virtuemart 2.0.24c

[roman5527]

Next error.

When I log how administrator i see error on priduct detail page :

vmError: getNeighborProducts Unknown column 'p.product_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `kr0ul_virtuemart_products` as `p` JOIN `kr0ul_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `kr0ul_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `kr0ul_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 19 and `l`.`slug` < "fever-be-koool" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY p.product_name DESC LIMIT 0,1
vmError: getNeighborProducts Unknown column 'p.product_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `kr0ul_virtuemart_products` as `p` JOIN `kr0ul_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `kr0ul_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`)   LEFT JOIN `kr0ul_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`)   WHERE `virtuemart_category_id` = 19 and `l`.`slug` > "fever-be-koool" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY p.product_name ASC LIMIT 0,1

can you help me how fix it ? thanks