Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
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
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
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 
Niels-Jørgen Hvidberg


njhvidberg.dk
Joined: 1/13/2004
Posts: 95
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
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
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
 
Erwin Craps


Joined: 2/12/2009
Posts: 22
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
 
Roger Selwyn


www.thedivingclub.co.uk
Joined: 9/23/2004
Posts: 3531
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
 
 Page 3 of 3
Previous123 
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.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out