News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Search error on VM 3.0.9.10

Started by luckysoft, September 23, 2015, 23:25:55 PM

Previous topic - Next topic

luckysoft

When i do a search on my VM shop i get an 1054 sql error like this:

Unknown column 'ld.product_name' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` , IF(pp.override, pp.product_override_price, pp.product_price) as product_price 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 JOIN `jos_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_manufacturers_en_gb` as m ON m.`virtuemart_manufacturer_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jos_virtuemart_product_prices` as pp ON p.`virtuemart_product_id` = pp.`virtuemart_product_id` WHERE ((`ld`.product_name LIKE "%fgd%" OR `l`.product_name LIKE "%fgd%" OR `p`.product_sku LIKE "%fgd%" OR `ld`.product_s_desc LIKE "%fgd%" OR `l`.product_s_desc LIKE "%fgd%" OR `ld`.product_desc LIKE "%fgd%" OR `l`.product_desc LIKE "%fgd%" OR `category_name` LIKE "%fgd%" OR `category_description` LIKE "%fgd%" OR `mf_name` LIKE "%fgd%") 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_price` ASC LIMIT 0, 100

I have no idea what causes this error, I've upgraded virtuemart from 3.0.2 to 3.0.9.10

When i do a blanc search it presents all the products in the store, no problem but when i search for any word a error turns up :(

My shop (3.0.9.10) is at http://www.aedsupermarkt.nl/webshop-na-update/ and the shop before the update can be found at http://www.aedsupermarkt.nl/webshop/

I've tryed the upgrade/migration tool -> install new or upgrade tables but that has no result at all :(

VM 3.0.9.10
Joomla 3.4.4

trevorbicewebdesign

What search extension are you using?
Never underestimate the power of stupid people in large groups.
http://webdesign.trevorbice.com/