http://our.umbraco.org/forum/core/general/NewTopic

Hey

Could anyone through me some helo ideas how to make it work :)

Steps:

1. Created awesome umbraco site localy

2. used "SQL Server export and import wizard" toll ins SQL server managment studio 2010 to copy datbase to remote server. Marking "Enable indentity insert"

3. Uploaded all local files to the server, via ftp

4. Changed we.config connection string with right data, umbracoDebugMode to false, compilatoion debug property to false

5. Login into backend , trying to publish getting some customError error, changing <customErrors mode="Off" /> in web.config

6. trying again to publish content

Server Error in '/' Application.

Cannot insert the value NULL into column 'id', table 'database.dbo.cmsContentVersion'; 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 'database.dbo.cmsContentVersion'; 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 'database.dbo.cmsContentVersion'; column does not allow nulls. INSERT fails.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1753346
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5295154
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +242
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1682
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +269
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) +1325
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +175
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) +205
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +160
   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) +78
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) +18
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +80

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
   umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +200
   umbraco.cms.businesslogic.Content.createNewVersion(DateTime versionDate) +380
   umbraco.cms.businesslogic.web.Document.PublishWithResult(User u) +260
   umbraco.cms.presentation.editContent.Publish(Object sender, EventArgs e) +241
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   umbraco.controls.ContentControl.savePublish(Object Sender, ImageClickEventArgs e) +46
   System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +115
   System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +124
   System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724

7. Searching whole web for answers - nothing ...

8. Posting here for a nice an easy fix :D

anyone knows what the problems may be ?

Thanks

Copy Link

Vilius Janulis 38 posts 79 karma points

Nov 29, 2012 @ 16:41

This forum is really buggy ..

Firstly : Could not post forum topics in google chrome at all.. something with ajax,js

This one is posted in firefox.

Then can not edit title - getting : "Error parsing XSLT file: \xslt\forum-commentsList.xslt" when trying to save main topic i created.

The title should be : Umbraco 4.10.1 migrating to remote server - cant publish sites

Copy Link

is working on a reply...

Flag this post as spam?

http://our.umbraco.org/forum/core/general/NewTopic

Server Error in '/' Application.

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

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