Post by stenzin » Fri Aug 26, 2011 1:47 am

Hi, I am using OpenCart 1.5.1.1 and I dont know if this is a bug within Opencart itself so I will post here for now.

If you look at this I have added 26 products under "Books" and from within OC Administration I see all 26 different books, from storefront some of the item from the 1st page is repeating on the 2nd page at same time some are missing which should be showing up as it says its enabled. Default show is set to 15 per page.

http://tibetgiftchicago.com/index.php?r ... ry&path=35

Now if you set the view to show "100" on each page then it displays all 26 different books and none are repeating.

http://tibetgiftchicago.com/index.php?r ... &limit=100

What could be causing this? I check to make sure Product code aren't same, which they aren't.

Thank you in advance for all help.

Tenzin
Last edited by stenzin on Sun Aug 28, 2011 1:38 am, edited 1 time in total.

Newbie

Posts

Joined
Sun Jan 30, 2011 5:27 am

Post by stenzin » Sat Aug 27, 2011 3:16 am

Well I thought it might be one of the extensions I have added so, I created a new store without any extensions and its doing the same thing.

Anyone else having the same issue?

Newbie

Posts

Joined
Sun Jan 30, 2011 5:27 am

Post by uksitebuilder » Sat Aug 27, 2011 4:18 am

The problem seems to lie with the default sort ordering (p.sort)

If you haven't given each product a sort order (most people don't) then this is what is causing the random behaviour. When page 2 is clicked, the query is run again but with a LIMIT 15,15 and so on.

As soon as you change to sort by A-Z etc it should work fine.

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by uksitebuilder » Sat Aug 27, 2011 4:19 am

It is not a bug as such, but I believe the default sort order would be better as p.product_id DESC

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by stenzin » Sun Aug 28, 2011 1:38 am

thanks uksitebuilder! got that fixed.

Newbie

Posts

Joined
Sun Jan 30, 2011 5:27 am

Post by stenzin » Mon Aug 29, 2011 1:22 am

sorry looks like its not fixed. I thought it worked but turned out its still the same.
can someone show me what i need to edit?

attached is my category.php from /catalog/controller/product/

EDIT: For now I have decided just to give each product sort order and it fixes it as you have stated, I will just go with this solution for now.

Newbie

Posts

Joined
Sun Jan 30, 2011 5:27 am

Post by ResoVic » Tue Sep 06, 2011 3:08 am

I have the same problem. I confirm that giving sort order works. I guess that will have to do for now

Newbie

Posts

Joined
Thu Sep 01, 2011 5:25 pm
Who is online

Users browsing this forum: No registered users and 49 guests