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 ForumsForumForumPeriodic Exception in Forum ModulePeriodic Exception in Forum Module
Previous
 
Next
New Post
11/20/2007 5:15 AM
 
Xexon

Joined: 10/19/2007
Posts: 7

Hey there,

One of my users recently reported her post going missing after she clicked update when posting to the forum. I looked for any errors but was unable to find any when posting. I logged in as SuperUser and I got a page load exception on the forum page. I could log out and back in and the exception was gone and the forum was running again. This ofcourse made me wonder, so after a lot of researching and trying things out, I can only reproduce the error when I'm logged in as superuser however it is the users that sometimes (very randomly) are unable to post.

I'm running 03.20.09 and I went into the Event Log to find out what the exception was:

AssemblyVersion: 04.05.01
PortalID: 0
PortalName: Det Grønlandske Hus i Odense
UserID: 1
UserName: oxygen
ActiveTabID: 165
ActiveTabName: Forum
RawURL:/OmHuset/Forum/tabid/165/scope/threads/forumid/2/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrerUserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.2)

DefaultDataProviderDotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProviderExceptionGUIDb18dd34e-5ae6-4b9d-9e2a-9c4e20533881
InnerException: Object reference not set to an instance of an object.FileNameFileLineNumber0FileColumnNumber0
    MethodDotNetNuke.Modules.Forum.Threads..ctorStackTraceMessageDotNetNuke.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.Forum.Threads..ctor(DNNForum forum)
        at DotNetNuke.Modules.Forum.DNNForum.CreateObject()
        at DotNetNuke.Modules.Forum.DNNForum.CreateChildControls()
        at System.Web.UI.Control.EnsureChildControls()
        at DotNetNuke.Modules.Forum.ForumBaseControl.EnsureChildControls()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Control.PreRenderRecursiveInternal()
        at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---Source

 

I am currently unable to reproduce the error, as it is completely random, but I really have no clue as to how to fix it. So if anyone knows what to do, I'd be very grateful.

Thanks in advance,

Michael
 
New Post
11/21/2007 12:46 AM
 
Chris Paterra


Joined: 4/5/2003
Posts: 4377

I would update to the forum version 4.4.3.

Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
11/21/2007 3:10 AM
 
Xexon

Joined: 10/19/2007
Posts: 7

Hey again and thanks for your reply,

However there was an error whilst installing the SqlProvider for 4.4.3 but 4up to .4.2 it ran in ok. Which now results in the forum not being viewable by anyone and I get the following error when going on to the site: "The stored procedure 'dbo.dnn_Forum_Forum_GetAll' doesn't exist."

I checked the EventLog again and there are two errors, first:

GENERAL_EXCEPTION:

AssemblyVersion: 04.05.01
PortalID: 0
PortalName: Det Grønlandske Hus i Odense
UserID: 1
UserName: oxygen
ActiveTabID: 165
ActiveTabName: Forum
RawURL: /OmHuset/Forum/tabid/165/Default.aspx
Absolute: URL/Default.aspx
AbsoluteURLReferrerUserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.2)
DefaultDataProviderDotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProviderExceptionGUID3d4daf4b-1dfb-40e7-8c4c-2102b7f24e2a
InnerException: The stored procedure 'dbo.dnn_Forum_Forum_Get' doesn't exist.FileNameFileLineNumber0FileColumnNumber0MethodSystem.Data.SqlClient.SqlCommand.DeriveParametersStackTrace
  MessageSystem.InvalidOperationException: The stored procedure 'dbo.dnn_Forum_Forum_Get' doesn't exist.
    at System.Data.SqlClient.SqlCommand.DeriveParameters()
    at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
    at DotNetNuke.Modules.Forum.SqlDataProvider.ForumGet(Int32 ForumID)
    at DotNetNuke.Modules.Forum.ForumController.GetForum(Int32 ForumId)
    at DotNetNuke.Modules.Forum.ForumInfo.GetForumInfo(Int32 ForumID)
    at DotNetNuke.Modules.Forum.ModuleSecurity..ctor(Int32 moduleId, Int32 tabId, Int32 ForumId, Int32 UserID)
    at DotNetNuke.Modules.Forum.ModuleSecurity..ctor(Int32 moduleId, Int32 tabId, Int32 ForumId, Int32 UserID)
    at DotNetNuke.Modules.Forum.Utils.PerUserModuleActions(Config ForumConfig, PortalModuleBase ModBase)
    at DotNetNuke.Modules.Forum.Container.get_ModuleActions()
    at DotNetNuke.Entities.Modules.PortalModuleBase.LoadActions()
    at DotNetNuke.Entities.Modules.PortalModuleBase.get_Actions()
    at DotNetNuke.UI.Skins.Skin.ProcessActionControls(PortalModuleBase objPortalModuleBase, Control objContainer)
    at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings)
Source

and then a:


PAGE_LOAD_EXCEPTION:

AssemblyVersion: 04.05.01
PortalID: 0
PortalName: Det Grønlandske Hus i OdenseUser
ID: 1
UserName: oxygen
ActiveTabID: 165
ActiveTabName: Forum
RawURL: /OmHuset/Forum/tabid/165/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrerUserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322; InfoPath.2)
DefaultDataProviderDotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProviderExceptionGUID5f225897-5861-45f8-90eb-0cbd81bbbbe6
InnerException: The stored procedure 'dbo.dnn_Forum_Forum_GetAll' doesn't exist.FileNameFileLineNumber0FileColumnNumber0MethodSystem.Data.SqlClient.SqlCommand.DeriveParametersStackTrace
MessageDotNetNuke.Services.Exceptions.PageLoadException: The stored procedure 'dbo.dnn_Forum_Forum_GetAll' doesn't exist. --->
  System.InvalidOperationException: The stored procedure 'dbo.dnn_Forum_Forum_GetAll' doesn't exist.
    at System.Data.SqlClient.SqlCommand.DeriveParameters()
    at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter)
    at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName)
    at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
    at DotNetNuke.Modules.Forum.SqlDataProvider.ForumGetAll(Int32 GroupID)
    at DotNetNuke.Modules.Forum.ForumController.ForumGetAll(Int32 GroupId)
    at DotNetNuke.Modules.Forum.GroupInfo.AuthorizedForums(Int32 UserID, Boolean NoLinkForums)
    at DotNetNuke.Modules.Forum.GroupController.GroupGetAllAuthorized(Int32 ModuleId, Int32 UserID, Boolean NoLinkForums)
    at DotNetNuke.Modules.Forum.Groups.CreateChildControls()
    at DotNetNuke.Modules.Forum.DNNForum.CreateChildControls()
    at System.Web.UI.Control.EnsureChildControls()
    at DotNetNuke.Modules.Forum.ForumBaseControl.EnsureChildControls()
    at DotNetNuke.Modules.Forum.DNNForum.Initialize()
    at DotNetNuke.Modules.Forum.ForumBaseControl.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.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---Source

 

And now it comes no matter what user level you're on.

Thanks again,

Michael
 
New Post
11/21/2007 5:25 AM
 
Xexon

Joined: 10/19/2007
Posts: 7

Hi again,

Thank you very much,

after a little wrestling I found the Stored Procedure and applied it, corrected the collation problems and violá the forum works again :)

Thanks Crispy :)
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumPeriodic Exception in Forum ModulePeriodic Exception in Forum Module


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