Copied to clipboard

Flag this post as spam?

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


  • jivan thapa 194 posts 681 karma points
    Jan 18, 2012 @ 15:01
    jivan thapa
    0

    Cannot insert the value NULL into column 'id'

    I got error while creating and publishing Content, after moving umbraco site from Localhost to server.

    -----> I used "Tasks ->Import Data" using Sql Server 2008 to transfer umbraco database. I also checked in "Enable Identity Insert"

    --------> I tried to save and create templates and  Document types. It works.

    -------> there is no problem to perform "Republish Entire site" .

    Problem is I can't create Content and I can't publish Content.

    How can i solve this problem?

    thanks

    /Jivan

     

  • jivan thapa 194 posts 681 karma points
    Jan 18, 2012 @ 15:02
    jivan thapa
    0

    Umbraco 4.7.1

  • Rodion Novoselov 694 posts 859 karma points
    Jan 18, 2012 @ 15:17
    Rodion Novoselov
    0

    Hi. It seems that the identity option of the "id" column is somehow turned to be off for the database table mentioned after importing data.

  • Adi 17 posts 36 karma points
    Jan 18, 2012 @ 15:28
    Adi
    0

    When you use Import data its not guaranted that the schema fully transfered. I have faced this problem with default values. I used the RedGate SQLCompare which resolved the problem. If you dont have redgate then first create schema and run on target server and then use import data.

     

Please Sign in or register to post replies

Write your reply to:

Draft