Welcome, Guest. Please login or register.
Login with username, password and session length


Need help or want to talk to other developers? Join the VirtueMart Chat! Read more...

  Advanced search

247038 Posts in 67506 Topics- by 258314 Members - Latest Member: aniketana
VirtueMart ForumVirtueMart 1.1.xAdministration & Configuration (Moderator: BanquetTables.pro)Product Scroller shows same product multiple times if in multiple categories
Pages: [1]   Go Down
Print
Author Topic: Product Scroller shows same product multiple times if in multiple categories  (Read 2244 times)
wndrbear
Newbie
*
Posts: 7


« on: October 03, 2008, 23:03:15 PM »

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
Logged
leocat
Newbie
*
Posts: 6



« Reply #1 on: October 17, 2008, 04:23:37 AM »

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

Kathrin
Logged
akeem76
Newbie
*
Posts: 18


« Reply #2 on: December 18, 2008, 02:13:05 AM »

I have the same problem too... still waiting for the solution.
Logged
wrangler
Jr. Member
**
Posts: 71


« Reply #3 on: May 19, 2010, 09:22:21 AM »

10 Joomla and 2 VM versions later, the problem is still there and no solution... Sad
Logged
zvd
Newbie
*
Posts: 2


« Reply #4 on: June 16, 2011, 14:26:04 PM »

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.
Logged
Pages: [1]   Go Up
Print
Jump to: