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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsA critical error has occurredA critical error has occurred
Previous
 
Next
New Post
11/13/2010 4:42 AM
 
If you run this, it should solve your problem. This issue seems to be becoming an increasingly common bug in DNN.

Update {databaseOwner}{objectQualifier}portals  set RegisteredRoleId  = 4 where portalid = 1

Cheers
Roger

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
11/14/2010 3:34 PM
Accepted Answer 
Thank you very, very much! The last script helped on this problem.
The script result that returned RoleId, PortalId and RoleName, can i use that for updating the other portals RoleId? They produce the same error when i click on Event Settings.

I can see in the upgrade log, that there was an error upgrading from 5.02.03 to 5.03.00. Here are the headlines:

System.Data.SqlClient.SqlException: There is already an object named 'ContentTypes' in the database. - - more details - -
System.Data.SqlClient.SqlException: There is already an object named 'AddScopeType' in the database. - - more details - -
System.Data.SqlClient.SqlException: There is already an object named 'DeleteVocabulary' in the database. - - more details - -
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_ContentTypes'. Cannot insert duplicate key in object 'dbo.ContentTypes'. - - more details - -
System.Data.SqlClient.SqlException: There is already an object named 'AddContentType' in the database. - - more details - -

I would mean its about that time the error showed up. I can send you the details if you think you can use them?

Thanks again for your great help.
Niels-Jørgen

Niels-Jørgen Hvidberg http://newcomtech.dk http://njhvidberg.dk
 
New Post
11/14/2010 4:48 PM
 
Yes you could use this to alter other portals RegisteredRoleID, if you edit it appropriately.

I dount the error you have shown here would cause the problem on the RegisteredRoleID, it looks like it is to do with the DNN search or tagging facility.

Cheers
Roger

DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
New Post
2/4/2011 11:17 AM
 
Having same issue. Ran the script, but no use. AssemblyVersion: 5.6.1 PortalID: 3 PortalName: Winksele-Delle UserID: 1 UserName: host ActiveTabID: 104 ActiveTabName: Activiteiten RawURL: /Activiteiten/tabid/104/ctl/EventSettings/mid/435/Default.aspx AbsoluteURL: /Default.aspx AbsoluteURLReferrer: UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET4.0C; .NET4.0E; InfoPath.3) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 48b1c24f-166d-44d8-afa8-5cf650c422b7 InnerException: Object reference not set to an instance of an object. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: DotNetNuke.Modules.Events.EventSettings.LoadNewEventEmailRoles StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Events.EventSettings.LoadNewEventEmailRoles(Int32 RoleID) at DotNetNuke.Modules.Events.EventSettings.LoadSettings() at DotNetNuke.Modules.Events.EventSettings.Page_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- Source: Server Name: INET02
 
New Post
2/4/2011 11:33 AM
 
Erwin Craps wrote:
Having same issue. Ran the script, but no use. AssemblyVersion: 5.6.1 PortalID: 3 PortalName: Winksele-Delle UserID: 1 UserName: host ActiveTabID: 104 ActiveTabName: Activiteiten RawURL: /Activiteiten/tabid/104/ctl/EventSettings/mid/435/Default.aspx AbsoluteURL: /Default.aspx AbsoluteURLReferrer: UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET4.0C; .NET4.0E; InfoPath.3) DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider ExceptionGUID: 48b1c24f-166d-44d8-afa8-5cf650c422b7 InnerException: Object reference not set to an instance of an object. FileName: FileLineNumber: 0 FileColumnNumber: 0 Method: DotNetNuke.Modules.Events.EventSettings.LoadNewEventEmailRoles StackTrace: Message: DotNetNuke.Services.Exceptions.PageLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Events.EventSettings.LoadNewEventEmailRoles(Int32 RoleID) at DotNetNuke.Modules.Events.EventSettings.LoadSettings() at DotNetNuke.Modules.Events.EventSettings.Page_Load(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- Source: Server Name: INET02

 If you ran the script mentioned above to update the RegisteredRoleID then that wasn't going to help. That updates the role on PortalID 1, whilst yours is PortalID 3 (as shown in your error)

You can find the right roleid by running this query:-
Select * from {databaseOwner}{objectQualifier}roles where portalid = 0 and RoleName = 'Registered Users'

You can then edit the previous query to do the update. You may also wish to correct the change you made to Portal 1.

Cheers
Roger


DNN MVP
Events - Get the latest version - Upgrade now!!
Feedback 6.4.2 - Now available - Give it a go!
Find us on Codeplex - DNN Events, DNN Feedback
Requirements/Bugs - Please submit them on Codeplex
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsEventsEventsA critical error has occurredA critical error has occurred


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.