Hi! This looks very promising! However I wasn't able to publish the Forum on my test-site (umb4.0.2.1 @ w2k+iis6+mssql). The Forum node and sample topics shows in the ui, but when I try publishing them I get an ysod.
Request information: Request URL: http://www.mysite.rocks/umbraco/editContent.aspx?id=1297 Request path: /umbraco/editContent.aspx User host address: 1.2.3.9 User: Is authenticated: False Authentication Type: Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information: Thread ID: 1 Thread account name: NT AUTHORITY\NETWORK SERVICE Is impersonating: False Stack trace: at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) at uForum.Businesslogic.Forum..ctor(Int32 forumID) at uForum.NewForumHandler.Document_AfterPublish(Document sender, PublishEventArgs e) at umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e) at umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) at umbraco.cms.presentation.editContent.Publish(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at umbraco.controls.ContentControl.savePublish(Object Sender, ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Could you try and check if the tables have been created correctly in your database? It should create 3 tables prefixed with "forum" in your umbraco DB.
What happens is, that on publish, an eventhandler will update the [forumForums] table with information about the node that is being published.
Did the SQL step of the package install correctly? Or is it possible that you have skipped the sql script part of the installer?
When you install the package, the last step loads a usercontrol. That has a button on it "install db" (or something). Inside the usercontrol is the sql script.
If you want to run it manually take a look at it here:
Just run that on your database, and you should be good to go.
I will look into making it a bit clearer that the last step of the installer is important. Or maybe just create a package action for it so it will run on its own.
Aha, thanks for that. And the reason it wasn't installed in the first place was probably that the script won't run in mssql 2000 (as I have on that server). I'll recreate the scripts and try again. I have umbraco running fine on my sql2000, however I see others having problems with it. Does Umbraco require SQL2005 or later perhaps?
Well, the XSLT extensions should have been added before the SQL script was supposed to run. But maybe some part of the package failed on sql 2000, or maybe something else went haywire. Anyways, I'm glad you got it working :-)
SQL helper Exception on publish
Hi! This looks very promising! However I wasn't able to publish the Forum on my test-site (umb4.0.2.1 @ w2k+iis6+mssql). The Forum node and sample topics shows in the ui, but when I try publishing them I get an ysod.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2009-06-27 21:45:34
Event time (UTC): 2009-06-27 19:45:34
Event ID: 2f56994c5c1f40a8b80ae9ad70a1f259
Event sequence: 382
Event occurrence: 5
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2117248975/Root-8-128906047920625000
Trust level: Full
Application Virtual Path: /
Application Path: C:\Inetpub\umbraco4\
Machine name: MY-SRV-10
Process information:
Process ID: 2000
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlHelperException
Exception message: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
Request information:
Request URL: http://www.mysite.rocks/umbraco/editContent.aspx?id=1297
Request path: /umbraco/editContent.aspx
User host address: 1.2.3.9
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at uForum.Businesslogic.Forum..ctor(Int32 forumID)
at uForum.NewForumHandler.Document_AfterPublish(Document sender, PublishEventArgs e)
at umbraco.cms.businesslogic.web.Document.FireAfterPublish(PublishEventArgs e)
at umbraco.cms.businesslogic.web.Document.PublishWithResult(User u)
at umbraco.cms.presentation.editContent.Publish(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at umbraco.controls.ContentControl.savePublish(Object Sender, ImageClickEventArgs e)
at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e)
at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Sounds like problems Authentication .... LOL. is specialized this way Windows, view connection properties.
Hi Jonas
Could you try and check if the tables have been created correctly in your database? It should create 3 tables prefixed with "forum" in your umbraco DB.
What happens is, that on publish, an eventhandler will update the [forumForums] table with information about the node that is being published.
Did the SQL step of the package install correctly? Or is it possible that you have skipped the sql script part of the installer?
Hi! Right, there are no forum-tables in the db. However no .sql-file in the package (0.0.7) either, what am I missing here?
Hi Jonas
When you install the package, the last step loads a usercontrol. That has a button on it "install db" (or something). Inside the usercontrol is the sql script.
If you want to run it manually take a look at it here:
http://uforum.codeplex.com/SourceControl/changeset/view/22228#430512
Just run that on your database, and you should be good to go.
I will look into making it a bit clearer that the last step of the installer is important. Or maybe just create a package action for it so it will run on its own.
Aha, thanks for that. And the reason it wasn't installed in the first place was probably that the script won't run in mssql 2000 (as I have on that server). I'll recreate the scripts and try again. I have umbraco running fine on my sql2000, however I see others having problems with it. Does Umbraco require SQL2005 or later perhaps?
Perhaps due to problems with the sql-script it did not either register the xslt extension uForum.
(I was able to publish the Forum now after I created the tables.)
Well, the XSLT extensions should have been added before the SQL script was supposed to run. But maybe some part of the package failed on sql 2000, or maybe something else went haywire. Anyways, I'm glad you got it working :-)
is working on a reply...