role management broken? - PLEASE HELP

[yusufm]

Hi,

I created a new role which disabled most modules and set the account options to "owner" only, and the roles shows up associated with the user in the user screen as well. But when I log in as the user, I see all modules.

Also, the new role appears below the table listing the default role, which is allow all. (don't know if this is a bug).

The new role seems to be associated with all users in the system. I tried deleting the association, but nothing seems to happen.

Also, when I created a record as user1. then log in and list as user2, i see the record (i should not, since the permissions are set as "owner") but also, I get the following error below the record view:

Error retrieving Account list: Query Failed SELECT meetings.id , meetings.name , meetings.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , meetings.date_start , meetings.parent_id , meetings.parent_type , meetings.time_start , meetings.assigned_user_id , 'meetings' panel_name FROM meetings AND jt0.deleted=0 where ((meetings.status='Planned')) AND meetings.deleted=0 ) UNION ALL ( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, tasks.date_due as date_start , tasks.parent_id , tasks.parent_type , tasks.time_due as time_start , tasks.assigned_user_id , 'tasks' panel_name FROM tasks AND jt0.deleted=0 where ((tasks.status='Not Started' OR tasks.status='In Progress' OR tasks.status='Pending Input')) AND tasks.deleted=0 ) UNION ALL ( SELECT calls.id , calls.name , calls.status , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) contact_name, ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start , calls.parent_id , calls.parent_type , calls.time_start , calls.assigned_user_id , 'calls' panel_name FROM calls AND jt0.deleted=0 where ((calls.status='Planned')) AND calls.deleted=0 ) ORDER BY date_start asc::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND jt0.deleted=0 where ((meetings.status='Planned')) AND meetings.deleted=0 ) U' at line 1

[jaucone]

I'm experiencing similar issues, but from the sales side. I want to see only my scheduled calls, tasks and meetings, and have my team see the same. Did you get a response or can the Sugar group help us with this?

Thanks,

Jeff

jeff.aucone@xplana.com

[yusufm]

So I got it working, but had to uninstall and reinstall everything. I think theres a bug in there somewhere, but i couldn't keep the system offline long enough to find it....