Author Topic: A small bug in the search plugin  (Read 464 times)

Ventsi Genchev

  • Jr. Member
  • **
  • Posts: 290
    • Audio Store
A small bug in the search plugin
« 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.
Audio Store:
https://vsystem.bg - Bulgarian language
https://vsystem.bg/en - English

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9942
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: A small bug in the search plugin
« Reply #1 on: January 14, 2019, 10:06:19 am »
Great, thank you. Is added.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/