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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Security RolesSecurity Roles
Previous
 
Next
New Post
7/16/2006 7:38 PM
 

I'm not sure if this is the correct forum, but I'm hopping someone can help. I have installed DNN3.2.1 and when I created the first child portal the default security roles were duplicated: -

Edit Administrators Portal Administration    
Edit Administrators Portal Administration    
Edit Registered Users Registered Users    
Edit Registered Users Registered Users    
Edit Subscribers A public role for portal subscriptions    
Edit Subscribers A public role for portal subscriptions    

This causes havoc with modules such as DnnBB.

Does anyone have a suggestion on how I can correct this?


Robin Cyber Factory DNN Hosting
 
New Post
11/2/2006 10:54 AM
 

I ran into this today and after some digging found the problem...at least for my installation.

I had created my own lists in the Host/List Editor.  One of them was for Gender where 'M' was the value for Male.  There is also a 'M' value for Monthly in the Frequency List.  The stored Procedure GetPortalRoles was written just to look for the value, not the value AND the ListName in the Join...so when it joined to the List table it was generating two rows for each role...  The corrected Stored procedure is below.  The "DNN_" prefix may be different in your installation, just replace it with whatever you use.  I've bolded the changes I made to the proc.

ALTER PROCEDURE [dbo].[DNN_GetPortalRoles]
@PortalId int
AS
SELECT R.RoleId,
R.PortalId,
R.RoleGroupId,
R.RoleName,
R.Description,
'ServiceFee' = case when convert(int,R.ServiceFee) <> 0 then R.ServiceFee else null end,
'BillingPeriod' = case when convert(int,R.ServiceFee) <> 0 then R.BillingPeriod else null end,
'BillingFrequency' = case when convert(int,R.ServiceFee) <> 0 then L1.Text else '' end,
'TrialFee' = case when R.TrialFrequency <> 'N' then R.TrialFee else null end,
'TrialPeriod' = case when R.TrialFrequency <> 'N' then R.TrialPeriod else null end,
'TrialFrequency' = case when R.TrialFrequency <> 'N' then L2.Text else '' end,
'IsPublic' = case when R.IsPublic = 1 then 'True' else 'False' end,
'AutoAssignment' = case when R.AutoAssignment = 1 then 'True' else 'False' end,
RSVPCode,
IconFile
FROM dbo.DNN_Roles R
LEFT OUTER JOIN dbo.DNN_Lists L1 on R.BillingFrequency = L1.Value AND L1.ListName = 'Frequency'
LEFT OUTER JOIN dbo.DNN_Lists L2 on R.TrialFrequency = L2.Value AND L2.ListName = 'Frequency'
WHERE PortalId = @PortalId
OR PortalId is null
ORDER BY R.RoleName
 
New Post
11/2/2006 3:51 PM
 

Thanks, I tried this on my installation and got the following error: -
Error: Security Roles is currently unavailable.

What I have done in the mean time is install a new instance of DNN (4.3.5) - all I have to do now is re-regiter about 30 users.


Robin Cyber Factory DNN Hosting
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Security RolesSecurity Roles


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