Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Jonas Eriksson 930 posts 1825 karma points
    Jun 27, 2009 @ 21:44
    Jonas Eriksson
    0

    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)

  • Michael Kearney (banned) 6 posts -33 karma points
    Jun 28, 2009 @ 03:43
    Michael Kearney (banned)
    -2

    Sounds like problems Authentication .... LOL.  is specialized this way Windows, view connection properties.

  • Morten Bock 1867 posts 2140 karma points MVP 2x admin c-trib
    Jun 28, 2009 @ 09:06
    Morten Bock
    1

    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?

  • Jonas Eriksson 930 posts 1825 karma points
    Jun 29, 2009 @ 09:15
    Jonas Eriksson
    0

    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?

  • Morten Bock 1867 posts 2140 karma points MVP 2x admin c-trib
    Jun 29, 2009 @ 09:22
    Morten Bock
    1

    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.

  • Jonas Eriksson 930 posts 1825 karma points
    Jun 29, 2009 @ 10:47
    Jonas Eriksson
    0

    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?

  • Jonas Eriksson 930 posts 1825 karma points
    Jun 29, 2009 @ 11:03
    Jonas Eriksson
    0

    Perhaps due to problems with the sql-script it did not either register the xslt extension uForum.

  • Jonas Eriksson 930 posts 1825 karma points
    Jun 29, 2009 @ 11:04
    Jonas Eriksson
    0

    (I was able to publish the Forum now after I created the tables.)

  • Morten Bock 1867 posts 2140 karma points MVP 2x admin c-trib
    Jun 30, 2009 @ 22:31
    Morten Bock
    0

    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 :-)

Please Sign in or register to post replies

Write your reply to:

Draft