Copied to clipboard

Flag this post as spam?

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


  • John Beauchamp 9 posts 30 karma points
    Feb 03, 2010 @ 00:09
    John Beauchamp
    0

    Server Error - When Installing Blog4Umbraco from Package

    Hello All,

    I get an error when installing the blog4Umbraco package from the repository.

    It looks like it is breaking when trying to add properties to the Blog Document type. I get the error while it is installing the package.

    After the error, it looks like the XSLT files and templates are installed. The Blog content type is also setup, and has all its tabs, but there are no properties in the tabs.

    I can also and create a blog in the content pane, but when I click on it the only tab with items in it is the properties one.

    • Umbraco: 4.0.3
    • asp.net version: 2.0.50727
    • iis version: Microsoft-IIS/6.0
    • Windows: server 2003 (I think...)


    Here is the stack trace:

    [SqlException (0x80131904): Cannot insert the value NULL into column 'id', table 'db8653.dbo.cmsPropertyType'; column does not allow nulls. INSERT fails.

    The statement has been terminated.]

       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890

       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875

       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194

       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392

       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204

       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954

       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162

       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175

       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137

       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +56

       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +83

       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelpers\SqlServer\SqlServerHelper.cs:64

       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:217


    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]

       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) in d:\TeamCity\buildAgent\work\7380c184e9fcd3ea\umbraco\datalayer\SqlHelper.cs:221

       umbraco.cms.businesslogic.propertytype.PropertyType.MakeNew(DataTypeDefinition dt, ContentType ct, String Name, String Alias) +266

       umbraco.cms.businesslogic.packager.Installer.ImportDocumentType(XmlNode n, User u, Boolean ImportStructure) +2614

       umbraco.cms.businesslogic.packager.Installer.InstallBusinessLogic(Int32 packageId, String tempDir) +2578

       umbraco.presentation.developer.packages.Installer.processInstall(String currentStep) +180

       umbraco.presentation.developer.packages.Installer.Page_Load(Object sender, EventArgs e) +334

       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14

       System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35

       System.Web.UI.Control.OnLoad(EventArgs e) +99

       umbraco.BasePages.BasePage.OnLoad(EventArgs e) +15

       System.Web.UI.Control.LoadRecursive() +50

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

    Any help or insight would be appreciated.  (Sorry if I triple posted this...)

     

    Thanks!

  • John Beauchamp 9 posts 30 karma points
    Feb 10, 2010 @ 23:51
    John Beauchamp
    0

    Hello All,

    Turns out the error was unrelated to the blog package. I am posting this in case some stumbles across this post with a similar error.

    The identity setting in the database had not been set properly. This database was not installed as part of a standard install and was created when moving from a development environment to production. This post lead me to discover what was wrong http://forum.umbraco.org/yaf_postst8661_Cannot-create-new-nodes-or-publish.aspx.

     

     

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies