hello,
I am getting the following error when logged in as a site host and trying to view site setting;-
DotNetNuke.Services.Exceptions.ModuleLoadException: The role 'Administrators' was not found. ---> System.Configuration.Provider.ProviderException: The role 'Administrators' was not found. at System.Web.Security.SqlRoleProvider.GetUsersInRole(String roleName) at System.Web.Security.Roles.GetUsersInRole(String roleName) at DotNetNuke.Security.Roles.RoleController.GetUsersInRole(Int32 PortalID, String RoleName) at DotNetNuke.Modules.Admin.PortalManagement.SiteSettings.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
I also get the following error when I try to log in as an administrator;-
A critical error has occurred.
Object reference not set to an instance of an object.
And finally the following error occurs when I try to manage users in roles;-
Error: User Roles is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The role 'Administrators' was not found. ---> System.Configuration.Provider.ProviderException: The role 'Administrators' was not found. at System.Web.Security.SqlRoleProvider.GetUsersInRole(String roleName) at System.Web.Security.Roles.GetUsersInRole(String roleName) at DotNetNuke.Security.Roles.RoleController.GetUsersInRole(Int32 PortalID, String RoleName) at DotNetNuke.Modules.Admin.Security.SecurityRoles.BindGrid() at DotNetNuke.Modules.Admin.Security.SecurityRoles.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---
I have had a look at the database, the tables;-
dotnetnuke4_UserRoles
dotnetnuke4_Users
dotnetnuke4_Roles
Are in order as far as I can see as follows;-
dotnetnuke4_Users
| 134 |
adminlogin |
admin |
guy |
False |
NULL |
xxx@xxxx.com |
| 1 |
host |
SuperUser |
Account |
True |
NULL |
xxx@xxxx.org.uk |
| NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
dotnetnuke4_UserRoles
| 267 |
134 |
1 |
NULL |
NULL |
| 268 |
134 |
2 |
NULL |
NULL |
| 269 |
134 |
0 |
NULL |
NULL |
| NULL |
NULL |
NULL |
NULL |
NULL |
USER: host/SuperUser has not got any roles defined in the UserRoles table
dotnetnuke4_Roles
| 0 |
0 |
Administrators |
Portal Administration |
0.0000 |
M |
-1 |
N |
-1 |
0.0000 |
False |
False |
| 1 |
0 |
Registered Users |
Registered Users |
0.0000 |
M |
-1 |
N |
-1 |
0.0000 |
False |
True |
| 2 |
0 |
Subscribers |
A public role for portal subscriptions |
0.0000 |
M |
-1 |
N |
-1 |
0.0000 |
True |
True |
| 4 |
1 |
Administrators |
Portal Administrators |
0.0000 |
M |
0 |
N |
0 |
0.0000 |
False |
False |
| 5 |
1 |
Registered Users |
Registered Users |
0.0000 |
M |
0 |
N |
0 |
0.0000 |
False |
True |
| 6 |
1 |
Subscribers |
A public role for portal subscriptions |
0.0000 |
M |
-1 |
N |
-1 |
0.0000 |
True |
True |
| 7 |
0 |
newsletter dist test |
test dist for newsletter |
0.0000 |
N |
1 |
N |
1 |
0.0000 |
False |
False |
| 9 |
0 |
photos |
loads photos to gallery |
0.0000 |
N |
1 |
N |
1 |
0.0000 |
False |
False |
| NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
NULL |
The look of things in the database as shown indicates as far as I can tell that everything shouldbe working perfectly. What am I missing?
Thank you...