next »

[wndrbear]

I have the product scroller set to scroll through 5 of the newest products.  But if one of the newest products has been placed in multiple categories, it is displayed in the scroller multiple times. E.g. if the product is in 2 categories, it will show up 2 times in the scroller, if it is in 3 categories it shows up 3 times.  As a result, the other products are not show, so in the case of the product being in 3 categories, then the scroller shows 3 time for the one product and only shows 2 of the other new products.

I'm hoping someone has found a fix for this.

I'm running Joomla 1.5.7 and VM 1.1.2. I do not have the Joomla cache turned on.

Thanks

[leocat]

Hi,
I've got the same problem - have there been any ideas yet?

Kathrin

[akeem76]

I have the same problem too... still waiting for the solution.

[wrangler]

10 Joomla and 2 VM versions later, the problem is still there and no solution...

[zvd]

I had the same problem with Ytc Virtuemart Extra Slider. After reading a post on duplicate search in vm plugin (https://forum.virtuemart.net/index.php?topic=45182.0), I tried the 'group by'. I've indicated product_id as my unique field. You also need to specify that field in the SELECT.

So it goes like this
line 143

Code:

$q  = "SELECT #__vm_product.*, #__{vm}_category.category_id, #__vm_product.product_id

line 173 (just before the ORDER BY)

Code:

$q .="group by #__vm_product.product_id";

It worked fine for me. I hope this can help you with Product Scroller.