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

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

Started by SamF, November 24, 2012, 18:05:38 PM

Previous topic - Next topic

SamF

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