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

Bug with advanced search module

Started by Xaman, May 10, 2012, 18:43:16 PM

Previous topic - Next topic

Xaman

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.

Xaman


tikos

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??
qb cube - internet solutions | web design & internet marketing
http://www.qbcube.com

Xaman

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.