Search Product

Hi ! , my web is http://xk000008.ferozo.com/

I have problems with the search engine. The default Joomla Search Engine doesnt find VM products.

And the VM search engine ( now published ), presents this error :

1054
Unknown column 'ld.product_name' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `lfpd9_virtuemart_products` as p INNER JOIN `lfpd9_virtuemart_products_en_gb` as l using (`virtuemart_product_id`) LEFT JOIN `lfpd9_virtuemart_product_shoppergroups` as ps ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` LEFT JOIN `lfpd9_virtuemart_product_categories` as pc ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id` LEFT JOIN `lfpd9_virtuemart_categories_en_gb` as cl ON cl.`virtuemart_category_id` = `pc`.`virtuemart_category_id` LEFT JOIN `lfpd9_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `lfpd9_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `lfpd9_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `lfpd9_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` WHERE ((`ld`.product_name LIKE "%mikonos%" OR `l`.product_name LIKE "%mikonos%" OR `ld`.product_s_desc LIKE "%mikonos%" OR `l`.product_s_desc LIKE "%mikonos%" OR `category_name` LIKE "%mikonos%" OR `category_description` LIKE "%mikonos%" OR `mf_name` LIKE "%mikonos%") 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 product_name ASC LIMIT 0, 18


Any Idea? Thanks

Some help ?. Please I paid for this template and doesn't work correctly

Hi

I believe this question should be asked to Virtuemart. Make sure component and all its extensions are up to date.

The error message makes me think Your VM datatabase doesn't match the code.

I solved the problem. When I used the option "Install or Update if is necessary" ( Tools > Tools & Migration ) the problem did dissapear

Thanks!

Hi

Great to hear that and thank You for shearing solution with us. Hopefully someone else will benefit from it.
I'm closing this thread now.