Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Tom Maton 387 posts 660 karma points
    Oct 02, 2009 @ 18:54
    Tom Maton
    0

    Cant create any new nodes

    Hi All,

    I cant seem to create any new nodes eg macros, pages, datatypes I keep getting the following errors:

     

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


    All I done was pass everything over to a staging site and change the database connectivity in the web config and now getting these issues.

    Any help would be greatly appreciated.

    Thanks

    Tom

    Copy Link
  • Rich Green 2246 posts 4008 karma points
    Oct 02, 2009 @ 20:31
    Rich Green
    0

    How did you transfer the database? It seems that the tables have lost the 'Identity' column. Open SQL Server Management studio, open the cmsMacro in design view. Select the id column and have a look to see if 'Identity Specification' is set to 'Yes', it should be.

    If it's not then you'll have continual problems as this setting will possibly be lost on all your tables.

    I assume you recreated the DB with a script? Another way would be to restore a database back up file to the staging site, this will ensure all the identity columns  are left in tact.

    Rich

    Copy Link
  • Tom Maton 387 posts 660 karma points
    Oct 03, 2009 @ 17:53
    Tom Maton
    0

    Hi Rich,

    I used the MS SQL DTS to transfer the database over.

    I would of thought that this would of kept all the tables integrtey?


    Tom

    Copy Link
  • Rich Green 2246 posts 4008 karma points
    Oct 04, 2009 @ 15:18
    Rich Green
    0

    It seems like it didn't, not sure it does by default.

    Can you check as I described above?

    Copy Link
  • Tom Maton 387 posts 660 karma points
    Oct 05, 2009 @ 18:43
    Tom Maton
    0

    Hi Rich,

    I will need to check tomorrow as I am not in hte office at the moment.

    But will let you know.

    Thanks again

    Tom

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies