[TYPO3-english] mpossnewssorting extension (tt_news)

Nubla II nublaii.typo3 at gmail.com
Thu Nov 13 17:32:27 CET 2008

I'm on the same boat with the reverse ordering ;)

For anybody else, this sql query will make your 'sorting' be the
'datetime' (run it right after you install it) ;)

UPDATE tt_news SET sorting = datetime;


> Grr.. i didn't test it well. It's all fine but one thing.. News records are
> in BE are sorted backwards (ASC) :-( .. I tried adding:
> $GLOBALS['TCA']["tt_news"]['ctrl']['sortby'] = 'sorting DESC';
> in ext_tables.php and then records are sorted fine but after i click up/down
> record the following error is produced:
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
> resource in /... t3lib/class.t3lib_db.php on line 741

More information about the TYPO3-english mailing list