Why why why why ! My store has been working the whole day and all of a sudden I get this error :-\ All I've been doing is populating the shop.
Unknown column 'l.category_name' in 'where clause' SQL=SELECT p.`virtuemart_product_id`, `l`.`product_name` FROM `vanilgef_virtuemart_products` as p INNER JOIN `vanilgef_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `vanilgef_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `vanilgef_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `vanilgef_virtuemart_categories_en_gb` as c ON c.`virtuemart_category_id` = `pc`.`virtuemart_category_id` WHERE ( `pc`.`virtuemart_category_id` = 2 AND ( `ps`.`virtuemart_shoppergroup_id`= "2" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) AND p.`virtuemart_product_id`!="5" AND `l`.category_name <= "Pies" ORDER BY `l`.category_name DESC LIMIT 1
please help.
you tell your joomla version, but not vm version