I am unable to edit or add Member Types in Umbraco 7.3.1.

There is no error message or saved message when editing in Umbraco.

I used the SQL Server Profiler to check if anything goes wrong inserting/updating certain fields and noticed that there is an error:

The INSERT statement conflicted with the FOREIGN KEY constraint "FKcmsPropertyTypecmsDataTypenodeId". The conflict occurred in database "Mydatabase", table "dbo.cmsDataType", column 'nodeId'.

The insert query that I think is creating the error is:

exec sp_executesql N'INSERT INTO [cmsPropertyType] ([dataTypeId],[contentTypeId],[propertyTypeGroupId],[Alias],[Name],[sortOrder],[mandatory],[validationRegExp],[Description],[UniqueID]) VALUES (@0,@1,@2,@3,@4,@5,@6,@7,@8,@9);
SELECT SCOPE_IDENTITY() AS NewID;',N'@0 int,@1 int,@2 nvarchar(4000),@3 nvarchar(4000),@4 nvarchar(4000),@5 int,@6 int,@7 nvarchar(4000),@8 nvarchar(4000),@9 nvarchar(40)',@0=0,@1=1044,@2=NULL,@3=N'umbracoMemberPasswordRetrievalAnswer',@4=N'Password Answer',@5=0,@6=0,@7=NULL,@8=NULL,@9=N'09c08c0b-b704-44a7-9570-175834b4dea3'

I found a few other forum post with a comparable situation:

• https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/71157-member-datatype-creation-sql-error
• https://our.umbraco.org/forum/developers/extending-umbraco//71053-member-datatype-creation-sql-error
• https://our.umbraco.org/forum/umbraco-7/using-umbraco-7/70921-issue-with-member-type-and-adding-and-deleting-properties

Some extra information:

I noticed that two fields were missing when comparing this database with another database with the same Umbraco version. What happened in the other Umbraco website is: when I saved the Member Type 'Member'. Two new Generic Properties were added. Password Answer and Password Question.

I hope that someone can help me with this issue. Thanks!

Michel Collard.