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

A small bug in the search plugin

Started by Ventsi Genchev, December 30, 2018, 01:34:16 AM

Previous topic - Next topic

Ventsi Genchev

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.
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/