[TYPO3-ttnews] tt_news list can't cahnge order

[Hauke Mehrtens]

Hi Peter

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'];


                }*/

I haven't tested it yet.

-- 
Hauke Mehrtens

Westpreußenweg 10
27442 Gnarrenburg
Tel.  : 04763/1745
Mobil : 0151/10778862
ICQ   : 160871207
Web   : www.hauke-m.de


Peter de Regt schrieb:
> Hi Hauke,
> 
> I hope that in the future there will be a bug fix for tt_news in combination 
> with this new Mysql version. If you find a solution, please let me know.
> 
> Greetings,
> Peter
> 
> "Hauke Mehrtens" <hauke at hauke-m.de> schreef in bericht 
> news:mailman.1.1200433562.20382.typo3-project-tt-news at lists.netfielders.de...
>> Hi
>>
>> It's working, but all news have to be in a category for that. Is there a
>> solution for news in no category?
>>
>> -- 
>>
>> Hauke Mehrtens
>>
>>
>> Hauke Mehrtens
>> Westpreußenweg 10
>> 27442 Gnarrenburg
>> Tel.  : 04763/1745
>> Mobil : 0151/10778862
>> ICQ   : 160871207
>> Web   : www.hauke-m.de
>>
>> Peter de Regt schrieb:
>>> Sorry I made a little mistake. I mentioned the item of Warren (7-12-2007)
>>> but that is not the right item.
>>> I wrote a workarround on bugs.typo3.org (issue tt_news 0007073):
>>>
>>> A workaround for this problem is by using categories. Normally you choose
>>> 'Show all' in the category selection.
>>> Now you choose 'Do NOT show items with selected category (OR)'.
>>>
>>> Greetings,
>>> Peter
>>>
>>>
>>> "Peter de Regt" <peter.de.regt at sharkit.nl> schreef in bericht
>>> news:mailman.1.1200429093.11795.typo3-project-tt-news at lists.netfielders.de...
>>>> Hi Ben,
>>>>
>>>> Thanx for your tip. But I don't think this is the solution. The newest
>>>> version of Mysql (5.0.51) in combination with tt_news is the problem.
>>>>
>>>> It happened me the day before christmas. My internetprovider just 
>>>> upgrades
>>>> the webserver. Since then i've got this problem. I descriped a 
>>>> workaround
>>>> for this (see the item of Warren on 7-12-2007), but this is not the 
>>>> final
>>>> solution.
>>>>
>>>> Greetings,
>>>> Peter
>>>>
>>>> "ben van 't ende [netcreators]" <ben at netcreators.com> schreef in bericht
>>>> news:mailman.1.1200426988.6347.typo3-project-tt-news at lists.netfielders.de...
>>>>> Hi Guys,
>>>>>
>>>>> The ever so busy Georg Ringer provides you with:
>>>>>
>>>>> http://www.rggooglemap.com/en/dev/chnewssort.html
>>>>>
>>>>> gRTz
>>>>>
>>>>> ben
>>>>>
>>>>>
>>>>>
>>>>> Peter de Regt wrote:
>>>>>> Hi Hauke,
>>>>>>
>>>>>> I've got the same problem. See also the item 'News events' of 
>>>>>> 7-12-2007
>>>>>> by
>>>>>> Warren Windvogel. I wrote a quick solution.
>>>>>>
>>>>>> Greetings,
>>>>>> Peter de Regt
>>>>>>
>>>>>>
>>>>>> "Hauke Mehrtens" <hauke at hauke-m.de> schreef in bericht
>>>>>> news:mailman.1.1200423214.18317.typo3-project-tt-news at lists.netfielders.de...
>>>>>>> I have setup a Typo3 page on my server and transfered it to an other,
>>>>>>> but now the tt_news records are ordered by the uid and not by the 
>>>>>>> date
>>>>>>> as it should.
>>>>>>>
>>>>>>> The one with the smallest uid is shown first and the one with the
>>>>>>> largest at the end.
>>>>>>>
>>>>>>> It doesn't work to delete the typoscript for tt_news and configure 
>>>>>>> the
>>>>>>> imported things in the flexforms. I have added a tt_news plugin and
>>>>>>> added the Object List and did nothing else with it.
>>>>>>>
>>>>>>> Is there any other value to configure the order?
>>>>>>>
>>>>>>> The live system with the error is hosted by 1und1 and has php 5.2.4 
>>>>>>> and
>>>>>>> mysql 5.0.51 with linux kernel 2.4