View Issues - Sorting by Column Not Working with MySQL4.1.21

guestusr · Post by **guestusr** » 17 Aug 2006, 12:00

Hello

We've been using Mantis 1.0.0 RC2 for almost 1 year now. Today we noticed that the column sorting in the "View Issues" page is not working i.e. the items are ALWAYS sorted by ID, no matter what filter I use (the default was "Last Updated").

This is making the application very hard to use as the most recent issues are always displayed at the end.

We updated to v1.0.5 but still the same problem is there, for all pages.

Version details:
Apache version 1.3.36 (Unix)
PHP version 4.4.2
MySQL version 4.1.21-standard

Can you please help ? We don't know how to get forward with this...

Thank you very much

Cosmin

shark · Post by **shark** » 17 Aug 2006, 12:57

Is this your issue?

http://bugs.mantisbt.org/view.php?id=7324

guestusr · Post by **guestusr** » 17 Aug 2006, 13:05

Yes - it's exactly our issue.

Sorry for not finding this in the bugs section.

Should we do what is written there i.e. deleting DISTINCT ?

Thanks again

shark · Post by **shark** » 17 Aug 2006, 13:10

I have no idea.

Removing that word from the query is not going to harm anything in the database, so maybe you could give it a try and post your results in the bug notes?

guestusr · Post by **guestusr** » 17 Aug 2006, 13:48

Done that. After removing "DISTICT" from line 856 of filter_api.php the sorting works ok. Thanks again.

jganders · Post by **jganders** » 20 Apr 2007, 19:04

guestusr wrote:Done that. After removing "DISTICT" from line 856 of filter_api.php the sorting works ok. Thanks again.

I just downloaded and installed the latest Mantis, I entered 48 bugs.
And this problem is STILL there! I took out the DISTINCT as specified and, sure enuf, the sorting now worx.

Mantis developers, please apply this fix.
(when you have time of course!)
Thanx!

Post by **vboctor** » 21 Apr 2007, 02:53

This is a MySQL problem, removing the DISTINCT causes issues to be displayed more than once in other scenarios. I think the My View page is one of such scenarios. You will need to upgrade to an update to date version of apply the MySQL patch. Hosting companies should take care of this for you if you raise it.