Copied to clipboard

Flag this post as spam?

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


  • Vilius Janulis 38 posts 79 karma points
    Nov 29, 2012 @ 16:37
    Vilius Janulis
    0

    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


  • Vilius Janulis 38 posts 79 karma points
    Nov 29, 2012 @ 16:41
    Vilius Janulis
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft