After installin rbam I got an SQL error. The following syntax is invalid.
SELECT id, username, email, createtime, lastvisit, superuser, status, DISTINCT(SUBSTR(username, 1, 1)) AS username FROM tbl_users t
To avoid this probmlem please change the rbam/controllers/AuthAssingmentsController.php araound line 77 to
$activeCharCriteria=new CDbCriteria(array(
// ‘select’=>"DISTINCT(SUBSTR($attribute,1,1)) AS $attribute"
'select'=>"SUBSTR(`$attribute`,1,1) AS `$attribute`",
'distinct'=>true,
));