I have a membertype usertype which has a number of properties, but when I try and add a new property the CMS whirrs and then doesn't report either a success or error but also does not update the member type property
the property i am trying to add is a simple True or False
if I try and delete a property I get the following error
the UPDATE statement conflicted with the FOREIGN KEY constraint "FKcmsPropertyTypecmsDataTypenodeId". The conflict occurred in database "UMBRACOXXX", table "dbo.cmsDataType", column 'nodeId'.
The statement has been terminated.
as part of updating the membertype one of the queries being run is being run with a a datatypeID o f 0 instead of using valid value for the FailEmail Attempts property
I just encountered something similar to this, when trying to add a property to a MemberType (tried unique or default/custom membertypes with same error).
I have just posted in the forum but probably in the wrong section:
Issue with member type and adding and deleting properties
I have a membertype usertype which has a number of properties, but when I try and add a new property the CMS whirrs and then doesn't report either a success or error but also does not update the member type property
the property i am trying to add is a simple True or False
if I try and delete a property I get the following error the UPDATE statement conflicted with the FOREIGN KEY constraint "FKcmsPropertyTypecmsDataTypenodeId". The conflict occurred in database "UMBRACOXXX", table "dbo.cmsDataType", column 'nodeId'. The statement has been terminated.
Any help appreciated sought begged for
okay discovered the issue sort of..
as part of updating the membertype one of the queries being run is being run with a a datatypeID o f 0 instead of using valid value for the FailEmail Attempts property
Hi Ravi
I just encountered something similar to this, when trying to add a property to a MemberType (tried unique or default/custom membertypes with same error).
I have just posted in the forum but probably in the wrong section:
Thread Link
Im not too familiar with the DB structure, would you be able to shed some light where the look for the potential cause ?
is working on a reply...