Copied to clipboard

Flag this post as spam?

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


  • sdfsfm 70 posts 94 karma points
    Sep 07, 2010 @ 12:26
    sdfsfm
    0

    Cannot insert the value NULL into column 'id'... - move from localhost to server

    Hi Guys i'm getting this error:

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

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

    Its a new installation @ softsyshosting.com. Basically what i did was copy the Db from local, which worked fine, uploaded all the files, which again worked fine. However as soon as i try to publish/create anything i get the error.

    Does anyone have a solution?

  • Atoosa Khoda 96 posts 148 karma points
    Feb 29, 2012 @ 04:56
    Atoosa Khoda
    0

    instaed of import/export, use backup/restore. looks like exporting database, looses the constraints. instaed backup your db and restore in the destination. eroors will disappear.

Please Sign in or register to post replies

Write your reply to:

Draft