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 ...Page Security Configuration Allows All Users to View and EditPage Security Configuration Allows All Users to View and Edit
Previous
 
Next
New Post
9/6/2010 1:20 PM
 
Since updating a multiportal site to 5.4.2, I am finding that new pages' security settings allow All Users to view and edit the page. The settings are displayed with padlocks, so can't be changed.

Anyone know what is causing this and / or a workaround please?


Paul Taylor
Dotcom Software Solutions Ltd
DotNetNuke, ASP.NET and SQL Server Development
 
New Post
9/6/2010 3:22 PM
 
You'll need to go into your database, the problem is that the "administrators" role for your portal is now defined as something other then admin. I have some SQL here in another post, if I can dig it up I will post it here.

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
9/6/2010 3:24 PM
 
Here's the SQL that you can run from the HOST/SQL page (always backup your database before running SQL that someone else provides), originally from this thread
http://www.dotnetnuke.com/Community/F...

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
9/6/2010 3:40 PM
 
Chris, thanks very much for that info. I checked out the portals table and both the AdministratorRoleId and RegisteredRoleId fields were set to -1 for the portal in question. After fixing both of these fields, correct functionality was restored.

Is this a known bug in 5.4.2?


Paul Taylor
Dotcom Software Solutions Ltd
DotNetNuke, ASP.NET and SQL Server Development
 
New Post
9/6/2010 3:47 PM
 
I think it was a fairly random issue, not all installs have the problem. Was the portal created after the upgrade?

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 ...Page Security Configuration Allows All Users to View and EditPage Security Configuration Allows All Users to View and Edit


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