Subcategory Order is wrong

marcus178 · Post by **marcus178** » 25 Feb 2009, 15:37

I am using 2.2.1 Beta and the subcategories are not in the same order as I have them in the administration. They seem to be ordered by ID instead.

Post by **Jan** » 27 Feb 2009, 21:26

Hi, I have tested it now and got it ordered by ordering ???

marcus178 · Post by **marcus178** » 02 Mar 2009, 14:09

I have attached screen shots so that you can see the frontend isn't ordering the same as the admin.

Picture 2.png

Post by **Jan** » 02 Mar 2009, 16:33

Ok this is the backend? Do you have some fronted to compare it?

marcus178 · Post by **marcus178** » 02 Mar 2009, 17:38

Sorry thought I'd added it already.

Picture 3.jpg

marcus178 · Post by **marcus178** » 03 Mar 2009, 19:15

It's definitely ordering by the id. I just went into the database and changed the id of one of the subcategories and the order changed.

marcus178 · Post by **marcus178** » 03 Mar 2009, 19:27

Ok. I found that in models/category.php if you comment out

' GROUP BY c.id'.

about line 513

this fixes the problem but I'm not sure if will have any effect on other things but it all seems to be ok.

bole · Post by **bole** » 13 Apr 2009, 09:57

This bug still exists in version 2.2.3.

The solution given by Marcus178 is working.

Post by **Jan** » 15 Apr 2009, 18:48

will be commented in next version, Jan

Phoca Forum