When i try to save a node in the content tree i get the following error message:
Cannot insert the value NULL into column 'id', table
'UmbracoConfetti.dbo.cmsPropertyData'; 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
'UmbracoConfetti.dbo.cmsPropertyData'; column does not allow nulls.
INSERT fails. The statement has been terminated.
Has the db been moved? The error sounds like the one you get when missing an identity property on the table that sometimes gets lost during db migration.
Error when saving document. Umbraco version 4.0.3
When i try to save a node in the content tree i get the following error message:
Cannot insert the value NULL into column 'id', table 'UmbracoConfetti.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.
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.The statement has been terminated.
Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'id', table 'UmbracoConfetti.dbo.cmsPropertyData'; column does not allow nulls. INSERT fails.
The statement has been terminated.
What to do?
Has the db been moved? The error sounds like the one you get when missing an identity property on the table that sometimes gets lost during db migration.
Is this done from the Umbraco UI or from some sort of component/user control/etc. ??
Yes the db was moved, and it is done from the Umbraco UI.
then the column 'id' in table 'UmbracoConfetti.dbo.cmsPropertyData
is missing - thats due to the migration.
You can add the identity of the column in your favorite db management program - make it similar to the source column.
If you use Microsoft SQL Server Database Publishing Wizard to do the migration everything normally comes out ok.
>Tommy
Id row already exsists in the dbo.cmsPropertyData.
id(int, not null)
yes, but it probably does not have the "identity" property set
The identity is set to false, but is there a way i can set it to true?
are you using some kind of visual studio to access your db? If so, you can open your table, find the ID column and change the property.
There's probably also an sql way - whcih I don't know right now
is working on a reply...