Description:
You'll try to create a new content type or save a new copy of an existing content and get the error "selected user does not exist."
The reason this occurs is that multiple admin accounts are set for the site, one or more of which is no longer valid.
Software Version: ecmcloud.piftech.com
Solution:
SQL code
SELECT TOP 1000 [ContentTypeId]
,[UserId]
,[PermissionLevel]
FROM [dbo].[ContentTypeUserPermission]
where userid not in (select id from Astria_Host.dbo.[User])
---***Step two if results are returned***---
-- DELETE FROM [dbo].[ContentTypeUserPermission]
--where userid not in (select id from Astria_Host.dbo.[User])
,[UserId]
,[PermissionLevel]
FROM [dbo].[ContentTypeUserPermission]
where userid not in (select id from Astria_Host.dbo.[User])
---***Step two if results are returned***---
-- DELETE FROM [dbo].[ContentTypeUserPermission]
--where userid not in (select id from Astria_Host.dbo.[User])