Error thrown when trying to delete a user who has published

For one of my clients, one of their admin users, who has published some pages previously, has left the organization and they want to remove this user. However, when trying to delete this admin user, the following error is thrown in the ColdFusion log.

The DELETE statement conflicted with the REFERENCE constraint “FKj1d2xof2vc5pfyt254wj5m184”. The conflict occurred in database “xxxxx”, table “dbo.cb_content”, column ‘FK_authorID’.

The version of ContentBox is 5.1.1+216 and is running on CF 2018 on Windows with MS SQL server.

May I ask if there is a way to remove this admin user please?

Hi @Monte_Chan . We have an open ticket on this issue. The problem is that you don’t want to delete the user and ALL of its contributions.

We have a ticket to basically assign all contributions to another user, then delete. However, that is still to be completed.

What you can do is just disable the user.

If you are an admin, you can see the admin fields. Deactivate the user and it’s basically a soft delete.

1 Like