TYPO3 Core

The select box of 'simulate frontend user group' is not sorted, the groups are displaied in the order they where added (uid).

That makes it realy hard to select a group out of a big list of groups.

Solution:

Replace the current exec_SELECTquery( in the file t3lib/class.t3lib_tsfebeuserauth.php on line 295 with:

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery(
'fe_groups.uid, fe_groups.title',
'fe_groups,pages',
'pages.uid=fe_groups.pid AND pages.deleted=0 '.t3lib_BEfunc::deleteClause('fe_groups').' AND '.$this->getPagePermsClause(1),
'',
'fe_groups.title ASC'
);
(issue imported from #M5593)