Multiple Rows in tblPropertyDefinitionType

Vote:
 

Hey,

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

engine.Initialize();

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.


#263752
Sep 24, 2021 16:17
Vote:
 

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

#263929
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.