[TYPO3-ttnews] Issue #7181: tt_news and MySQL 5+ is not resolved

[Francois Suter]

Hi all,

The problem with the seemingly random sorting of the news items 
described in bug #7181 (http://bugs.typo3.org/view.php?id=7181) is not 
resolved contrary to what is indicated there. Replacing the GROUP BY 
tt_news.uid by adding DISTINCT(tt_news.uid),tt_news.* creates the exact 
same problem. Removing DISTINCT(tt_news.uid) solved the problem, the 
sorting by date is respected. Obviously this will again create duplicate 
item problems when using categories, so it seems a better solution must 
be found, but I have no time dig into that now.

Cheers

-- 

Francois Suter
Cobweb Development Sarl - http://www.cobweb.ch