Hi,
My VirtueMart advanced search module is acting buggy. When I try doing a search I get an error message:
mError: exeSortSearchListQuery Column 'created_on' in where clause is ambiguous SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `eunz4_virtuemart_products_pt_pt` as l JOIN `eunz4_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `eunz4_virtuemart_product_categories` ON p.`virtuemart_product_id` = `eunz4_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `eunz4_virtuemart_categories_pt_pt` as c ON c.`virtuemart_category_id` = `eunz4_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `eunz4_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `eunz4_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `eunz4_virtuemart_manufacturers_pt_pt` as m ON m.`virtuemart_manufacturer_id` = `eunz4_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `eunz4_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `eunz4_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `eunz4_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `eunz4_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE (`product_name` LIKE "%shovel%" OR `created_on` LIKE "%shovel%" OR `product_sku` LIKE "%shovel%" OR `product_s_desc` LIKE "%shovel%" OR `product_desc` LIKE "%shovel%" OR `category_name` LIKE "%shovel%" OR `category_description` LIKE "%shovel%" OR `mf_name` LIKE "%shovel%" OR `product_height` LIKE "%shovel%" OR `product_lwh_uom` LIKE "%shovel%" AND p.`published`="1" AND (s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shoppergroup_id`) IS NULL )) group by p.`virtuemart_product_id` ORDER BY p.virtuemart_product_id ASC LIMIT 0, 10
Anyone knows what could be causing this?
I'm using Joomla 2.5.4 and VirtueMart 2.0.6.
Anyone??? :-\
At least, can anyone tell us where the Advanced Search Module is? I installed virtuemart 2.0.6 on Joomla 2.5.4, but I only found VM Search Module in Module Manager.
How can I use the Advanced Search??
Quote from: tikos on May 20, 2012, 19:18:33 PM
At least, can anyone tell us where the Advanced Search Module is? I installed virtuemart 2.0.6 on Joomla 2.5.4, but I only found VM Search Module in Module Manager.
How can I use the Advanced Search??
You need to install the virtuemart_ext component, which includes all the plugins and modules. It comes with the complete package.