Hi all,

I added new fields to the Member doctype. After I added those fields, every existing member that I had couldn't be updated. I received the following exception:

Cannot insert duplicate key row in object 'dbo.cmsPropertyData' with unique index 'IXcmsPropertyData1'. The duplicate key value is (418773, 6f45a52c-2a9a-4d54-8981-846ce96c32c9, 920). The statement has been terminated.

Exception Details System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.cmsPropertyData' with unique index 'IXcmsPropertyData1'. The duplicate key value is (418773, 6f45a52c-2a9a-4d54-8981-846ce96c32c9, 920). The statement has been terminated.

I know for sure that if I create a new member after I created those new parameters, everything works for that specific member, but I cannot save old members that were created BEFORE adding those parameters,

Another hint: in the CmsPropertyData table, for the specifice versionID that appeared in the exception details (418773, 6f45a52c-2a9a-4d54-8981-846ce96c32c9) the field propertytypeid with a value of 920 did not gave me any results, so I infer that from some reason, on old users, the newly created fields data is not inserted to the DB.

Any help will be highly appreciated.

Thanks