I actually don't have any roles created. I tried creating a role, and I got the following error:

Cannot insert the value NULL into column 'ACTION_ID', table 'SplendidCRM.dbo.ACL_ROLES_ACTIONS'; column does not allow nulls. INSERT fails. The statement has been terminated.

Another odd thing I noticed is that if I search role by user, "Reports" is not even listed in the options.

I'm using SplendidCRM Community Version 4.4.3855.40423 (SugarCRM Version 4.5.0)

This is what I had installed initially, and I re-ran the database script. While modifying, I had run into other issues that rerunning Setup.exe in the sql server express folder had fixed before, but this time it didn't help.

I have added several new modules, but I don't remember doing anything to the ACL_Roles table. If I do: * from vwMODULES_TabMenu

the Reports module shows up, and so do the new modules I have added. However when I do: * from vwMODULES_TabMenu_byUser

The reoprts module doesn't show up. There are no entries in the ACL_Roles tables.

select

select