VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: skrystos on December 12, 2012, 20:36:04 PM

Title: Search module doesn't work on VM 2.0.14 & Joomla 2.5.8
Post by: skrystos on December 12, 2012, 20:36:04 PM
When I open debug mode I've got such error:

"JDatabaseMySQL::query: 1054 - Unknown column 'p.product_sku' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS l.`virtuemart_product_id` FROM `j25_virtuemart_products_pl_pl` as l JOIN `j25_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `j25_virtuemart_product_categories` ON p.`virtuemart_product_id` = `j25_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `j25_virtuemart_categories_pl_pl` as c ON c.`virtuemart_category_id` = `j25_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `j25_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `j25_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `j25_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `j25_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE ((`p.product_sku` LIKE "%czujnik%" OR `c.category_name` LIKE "%czujnik%" OR `c.category_description` LIKE "%czujnik%" OR `m.mf_name` LIKE "%czujnik%" OR `p.product_name` LIKE "%czujnik%" OR `p.product_s_desc` LIKE "%czujnik%") AND p.`published`="1" AND `j25_virtuemart_product_categories`.`virtuemart_category_id` > 0 AND ( s.`virtuemart_shoppergroup_id`= "1" OR s.`virtuemart_shoppergroup_id` IS NULL ) ) group by p.`virtuemart_product_id` ORDER BY product_name ASC LIMIT 0, 10"

When I try to search anything on the shop, I've got no results. When I use joomla search module I've got full results. All modules and plugins needed to work are installed. Please help me with that because I don't know what to do. This is first time I've got such issue. I have few virtuemart shops (earlier vesrions) and there is everything fine.
Title: Re: Search module doesn't work on VM 2.0.14 & Joomla 2.5.8
Post by: Milbo on December 18, 2012, 16:46:36 PM
I was not able to reproduce this, but maybe we fixed it already, you did not write which version you are using. But due your post I found another small error and fixed it imho, next version then 2.0.15f