Good for the component, but nothing appears in the search bar...


Sorry and thank you

I tried :
WHERE '.implode(' OR ', $wheres).' OR p.`product_sku` LIKE ' . $db->Quote('%'.$filter.'%').' OR p.`product_barcode` = ' . $db->Quote('%'.$filter.'%').' OR p.`product_isbn` = ' . $db->Quote('%'.$filter.'%'), 0, 50);

But it's the same thing...

Hello. Version with "%" placeholders needs LIKE clause, not =.
What is your version of VM? And can you confirm that these two columns product_isbn and product_barcode are really in virtuemart *_products table? Thanks.

Edit: you can try to enable Joomla system debug and error reporting to Maximum, so you can see if there are some SQL errors in ajax search.

Hello, my VM version is 1.1.9
yes, this two colunms are in virtuemart *_products

thanks

Hi, ah, I was thinking that. You must edit condition branch below for VM1. Like that

else
$db->setQuery('SELECT `product_id` AS `id`,`product_name`, `product_sku`, product_in_stock
FROM `#__vm_product`
WHERE `product_name` LIKE ' . $db->Quote('%' . $filter . '%').' OR `product_sku` LIKE ' . $db->Quote('%' . $filter . '%')
.' OR `product_barcode` = ' . $db->Quote($filter).' OR `product_isbn` = ' . $db->Quote($filter), 0, 50);

Good job, thank you very much.... That' work...
ARTIO = very serious, very good
Thank's & best regards

Gaël