Print Page - 2.0.14 - Joomla search plugin for Virtuemart: possible mis-typing in SQL query

Title: 2.0.14 - Joomla search plugin for Virtuemart: possible mis-typing in SQL query
Post by: SamF on November 24, 2012, 18:05:38 PM

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:

... b.virtuemart_category_id>0

Otherwise category 1 will always be skipped in search results.

Regards

VirtueMart Forum