button search

[daltan75]

Hi, great support!

I have another problem whit my site: giadapetshop.com
when i search anything on my VM search product module, I have this error page:

Unknown column 'ld.product_name' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `jos_virtuemart_products` as p INNER JOIN `jos_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_categories_en_gb` as cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT OUTER JOIN `jos_virtuemart_products` children ON p.`virtuemart_product_id` = children.`product_parent_id` WHERE ((`ld`.product_name LIKE "%lattina%" OR `l`.product_name LIKE "%lattina%" OR `p`.product_sku LIKE "%lattina%" OR `ld`.product_s_desc LIKE "%lattina%" OR `l`.product_s_desc LIKE "%lattina%" OR `ld`.product_desc LIKE "%lattina%" OR `l`.product_desc LIKE "%lattina%" OR `category_name` LIKE "%lattina%" OR `category_description` LIKE "%lattina%") AND ( (p.`product_in_stock` - p.`product_ordered`) >"0" OR (children.`product_in_stock` - children.`product_ordered`) > "0") AND ((p.`product_parent_id` = "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` > "0") AND ((p.`product_parent_id` > "0" AND `pc`.`virtuemart_category_id` > "0") OR p.`product_parent_id` = "0") AND ( `ps`.`virtuemart_shoppergroup_id`= "1" OR `ps`.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`="1" ) group by p.`virtuemart_product_id` ORDER BY `pc`.`ordering`,`product_name` ASC LIMIT 0, 99

I don't know what can I do please help me.

[jenkinhill]

Search the forum for the error?

http://forum.virtuemart.net/index.php?topic=131550
http://forum.virtuemart.net/index.php?topic=131613