Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cannot unlock security role permissionsCannot unlock security role permissions
Previous
 
Next
New Post
6/10/2010 8:02 PM
 
Coz, email me if you can. I would be interested in taking a look at your database if you could give me access. I am curious to see what is causing this, I imagine it is something in the Roles table.

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
6/10/2010 9:24 PM
 
So anyone else having this problem is going to need to look at the Portals table in your database. In Coz's case the AdministratorRoleID was set to this other role, not the role called Administrators, I believe once Coz makes the change using SQL Script that everything will be fine again.


Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
6/10/2010 11:17 PM
 
My guess is that the portals with this issue were created with a Template, can anyone else confirm this when they have the problem?

Here is some SQL that you can run in the HOST/SQL Window to fix this on portals 
(as with all SQL please backup your website/database prior to running this, just in case something breaks!, use at your own risk, etc)

update {databaseOwner}{objectQualifier}portals
set
AdministratorRoleId = (select roleid 
	from {databaseOwner}{objectQualifier}Roles 
	where {databaseOwner}{objectQualifier}Roles.PortalID
		={databaseOwner}{objectQualifier}Portals.PortalID 
	and RoleName = 'Administrators')

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
6/13/2010 6:29 AM
 
Hi Chris,

I have the same issue with every new portal I create. In the Roles table, AdministratorRoleId and RegisteredRoleId are set to -1. I create the new portal with the default template.

Best wishes from Germany
Torsten Weggen

dotnetnuke.blog. DNN Usergroup German Speaking Area Eurepean Network of DotNetNuke Professionals
 
New Post
6/13/2010 12:35 PM
 
Weggetor, what version of DNN are you running?

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cannot unlock security role permissionsCannot unlock security role permissions


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out