[TYPO3-UG Dutch] tt_news categorie problemen bij upgrade MySQL versie 5.0.51 en PHP 5.2.5

[Peter de Regt]

Zojuist via het typo3.english het antwoord gekregen van Hauke Mehrtens. Zie 
onderaan deze email voor de bugfix. Ik heb het zojuist getest en dit is de 
oplossing dus voor dit probleem.

Met vriendelijke groet,
Peter de Regt
Shark IT

------
After searching a little bit around I fond a post in a German forum:
http://www.typo3.net/index.php?id=13&action=list_post&tid=71875&page=1

They have a solution for this problem.

tt_news generate queries like this:
SELECT ... FROM ... WHERE ... *GROUP BY* ... ORDER BY datetime DESC

Before version 5.0.51 the *GROUP BY* will be ignored by mysql, but now it 
produces an error.

To prevent tt_news from generating the GROUP BY in the query, delete the
following lines out of pi/class.tx_ttnews.php


// GROUP BY
                /*if (trim($conf['groupBy']))   {
                        $queryParts['GROUPBY'] = trim($conf['groupBy']);
                        $query.=' GROUP BY '.$queryParts['GROUPBY'];
                }*/

--------------