This may solve your problem. Ajax live search results, as the customer types in keywords. It works much better than the VM product search, which as you stated does not work.
Thanks for the info, but i want that this module work correctly!
I see this error with Joomla Debug ON (i have searched the word "brioso" with the module!)
JDatabaseMySQL::query: 1064 -
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'published`="1" AND (s.`virtuemart_shoppergroup_id`= "1" OR (s.`virtuemart_shopp' at line 4 SQL=SELECT SQL_CALC_FOUND_ROWS * FROM `j17_virtuemart_products_it_it` as l JOIN `j17_virtuemart_products` AS p using (`virtuemart_product_id`) LEFT JOIN `j17_virtuemart_product_categories` ON p.`virtuemart_product_id` = `j17_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `j17_virtuemart_categories_it_it` as c ON c.`virtuemart_category_id` = `j17_virtuemart_product_categories`.`virtuemart_category_id` LEFT JOIN `j17_virtuemart_product_manufacturers` ON p.`virtuemart_product_id` = `j17_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `j17_virtuemart_manufacturers_it_it` as m ON m.`virtuemart_manufacturer_id` = `j17_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `j17_virtuemart_product_shoppergroups` ON p.`virtuemart_product_id` = `j17_virtuemart_product_shoppergroups`.`virtuemart_product_id` LEFT OUTER JOIN `j17_virtuemart_shoppergroups` as s ON s.`virtuemart_shoppergroup_id` = `j17_virtuemart_product_shoppergroups`.`virtuemart_shoppergroup_id` WHERE (`product_name` LIKE "%brioso%" OR `product_sku` LIKE "%brioso%" OR `product_s_desc` LIKE "%brioso%" OR `product_desc` LIKE "%brioso%" OR `category_name` LIKE "%brioso%" OR `category_description` LIKE "%brioso%" OR `mf_name` LIKE "%brioso%"
OR `p`.`virtuemart_product_id`` LIKE "%brioso%" 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 product_sku ASC LIMIT 0, 30
In red you see
OR `p`.`virtuemart_product_id`` ... i'm wrong or i see too much single quotation marks?
And
OR (s.`virtuemart_shopp'... i think it is truncated...
Here the call stack with the lines where the error occured
# Function Location
1 JSite->dispatch() JROOT/index.php:42
2 JComponentHelper::renderComponent() JROOT/includes/application.php:198
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:357
4 require_once() JROOT/libraries/joomla/application/component/helper.php:388
5 JController->execute() JROOT/components/com_virtuemart/virtuemart.php:103
6 VirtueMartControllerCategory->display() JROOT/libraries/joomla/application/component/controller.php:754
7 VirtuemartViewCategory->display() JROOT/components/com_virtuemart/controllers/category.php:56
8 VirtueMartModelProduct->getProductsInCategory() JROOT/components/com_virtuemart/views/category/view.html.php:138
9 VirtueMartModelProduct->sortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:779
10 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:419
11 JDatabase->loadResultArray() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:366
12 JDatabase->loadColumn() JROOT/libraries/joomla/database/database.php:1800
13 JDatabaseMySQL->query() JROOT/libraries/joomla/database/database.php:936
14 JError::raiseError() JROOT/libraries/joomla/database/database/mysql.php:542
15 JError::raise() JROOT/libraries/joomla/error/error.php:251