Author Topic: 2.0.14 - Joomla search plugin for Virtuemart: possible mis-typing in SQL query  (Read 2035 times)

SamF

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 101
    • virtuext.com
Hello,

J2.5.8 +VM2.0.14

Code: (..\plugins\search\virtuemart\virtuemart.php about line 276) [Select]
$query = "SELECT ....
        . ' WHERE ' . $where . ' and p.published=1 and b.virtuemart_category_id>1 '
        . ' ORDER BY ' . $order;

Possibly mis-typed, should be:
Code: [Select]
... b.virtuemart_category_id>0
Otherwise category 1 will always be skipped in search results.

Regards