Old Forums
Search:
Technical support This forum is closed.
Version 1.x > Technical support > Cannot insert the value NULL into column View modes: 
User avatar
Member
Member
Kim Abela - 7/14/2006 12:22:43 PM
   
Cannot insert the value NULL into column
Hello,

When I migrate the SQL DB from the testing server to the production server I'm facing an error saying "Kentico.CMS.DataProviderSQL.ExecuteQuery.....Cannot insert the value NULL into column UserID table" when creating new user and the same when trying to create new MenuItem.

Any suggestions,

Thank you

Kim

User avatar
Guest
admin - 7/17/2006 4:33:48 PM
   
Re: Cannot insert the value NULL into column
Hello,

Thank you for your message. Did you use backup/restore or DTS to move the database? Could you please check if the CMS_User table has the identity ON on the UserID column?

Thank you.

Best Regards,

Top