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,
));