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.
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.
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.
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!
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.
is working on a reply...
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.