Publishing Failure

Hey again.

Carrying on from my install i now have all the files of the existing site moved acrossed. However when i publish i now receive the following error:

Server Error in '/' Application.

Cannot insert the value NULL into column 'id', table 'SAHFOSCMS.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'id', table 'SAHFOSCMS.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Source Error:


An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of
the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Cannot insert the value NULL into column 'id', table 'SAHFOSCMS.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +212
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2811
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +2481516
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +2483169
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +522
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +182
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +89
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +105
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) +36
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +88

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +212
   umbraco.cms.businesslogic.property.Property.MakeNew(PropertyType pt, Content c, Guid versionId) +406
   umbraco.cms.businesslogic.Content.createNewVersion() +416
   umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +254
   umbraco.dialogs.publish.Page_Load(Object sender, EventArgs e) +1738
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   umbraco.BasePages.BasePage.OnLoad(EventArgs e) +21
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

Any Ideas?

thanks

Alec

Copy Link

Alec Colebrook-Clark 134 posts 258 karma points

Nov 25, 2009 @ 15:48

0

Nevermind! We just recopied the database back over, it seems like its working!

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?

Publishing Failure

Server Error in '/' Application.

Cannot insert the value NULL into column 'id', table 'SAHFOSCMS.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.The statement has been terminated.

Cannot insert the value NULL into column 'id', table 'SAHFOSCMS.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.
The statement has been terminated.