Contest ended - sorting by Rating does not work - Page 2

Chuck S · January 22nd, 2011, 02:55 PM

I can look at it again but the changes I showed works. Its all about debugging and seeing why your sort is the way it is. sorts are cookied or passed in a url so one needs to consider that when dealing with the issue as well. If your cookied with a sort variable then your sort is going to be that variable.

jdougher · January 22nd, 2011, 03:05 PM

Quote:

Originally Posted by Chuck S

I can look at it again but the changes I showed works. Its all about debugging and seeing why your sort is the way it is. sorts are cookied or passed in a url so one needs to consider that when dealing with the issue as well. If your cookied with a sort variable then your sort is going to be that variable.

How to clear the cookies then?

jdougher · January 23rd, 2011, 05:40 AM

Quote:

Originally Posted by Chuck S

I can look at it again but the changes I showed works. Its all about debugging and seeing why your sort is the way it is. sorts are cookied or passed in a url so one needs to consider that when dealing with the issue as well. If your cookied with a sort variable then your sort is going to be that variable.

Actually I tried logging in as different users (different cookes, I presume), and the sort order, previously broken, was fixed there too.

Chuck S · January 23rd, 2011, 08:47 AM

yeah which is why I said I would look into it more. The fix I noted above should explicitly set the sort to votes which is a column in the photos table. This alteration was already included in the upcoming 7.1 release. It will be a few before I have an answer.

Chuck S · January 23rd, 2011, 07:50 PM

I just verified the changes I noted which are going to be in 7.1 work fine.

Reefs - ReefTalk Gallery

If you make the changes I noted in this thread it will work because it explicitly sets the sort.

Did you do the insert into the sorts table?

INSERT INTO pp_sort VALUES (9,'Votes', 'ORDER BY disporder,votes DESC');