VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Ventsi Genchev on December 30, 2018, 01:34:16 AM

Title: A small bug in the search plugin
Post by: Ventsi Genchev on December 30, 2018, 01:34:16 AM
There is a small bug in the search plugin that Joomla's search engine sometimes shows unpublished products.
The problem is in the file:
/plugins/search/virtuemart/virtuemart.php

The line:
" WHERE {$where} " .
Must be:
" WHERE ({$where}) " .

When the whole clause "$where" is not enclosed in brackets, according to the search method (exact/all/any), where to look for (description/custom fields) and what is sought sometimes ignored "AND p.published = 1", " AND c.virtuemart_category_id > 0" and shoppergroup.
Title: Re: A small bug in the search plugin
Post by: Milbo on January 14, 2019, 10:06:19 AM
Great, thank you. Is added.