Multiple Rows in tblPropertyDefinitionType



We have recently written an app that will use the CMS API's to create blocks for us.  The application uses 


When that is run the following stored procedure is called:

exec netContentTypeDelete @ContentTypeID=484

This stored procedure fails saying

System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Looking at the stored procedure the problem is I have 7 duplicate guids in the table tblPropertyDefinitionType. This is only on our production db. Does anyone know how to solve this in a safe way? I am not even sure what that tabel is used for. I also have no idea why it is trying to delete that content type as it is valid.

Sep 24, 2021 16:17

Do you by any chance have different block types using same GUID?

Sep 27, 2021 10:51
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.