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=484This 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.
Do you by any chance have different block types using same GUID?