Error deleting a user "Failed to delete the user {ID}"
Umbraco version 7.13.2 assembly: 1.0.6974.19955
UI error:
Server error: Contact administrator, see log for full details.
Failed to delete the user 13
Log Error:
System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FKumbracoUserLoginumbracoUser_id". The conflict occurred in database "HABCINTDB", table "dbo.umbracoUserLogin", column 'userId'.
The statement has been terminated.
Details:
Yes, there are records in table umbracoUserLogin for the user that I am trying to delete:
SELECT dbo.umbracoUserLogin.*
FROM dbo.umbracoUserLogin
WHERE (userId = 13)
and seems the database constraint is set on delete no action... is this by design?
Proposed Solution:
Set on delete cascade for this particular database constraint. this basically means deleting a user will wipe off all of their login logs
Error deleting a user "Failed to delete the user {ID}"
Umbraco version 7.13.2 assembly: 1.0.6974.19955
UI error: Server error: Contact administrator, see log for full details. Failed to delete the user 13
Log Error: System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FKumbracoUserLoginumbracoUser_id". The conflict occurred in database "HABCINTDB", table "dbo.umbracoUserLogin", column 'userId'. The statement has been terminated.
Details: Yes, there are records in table umbracoUserLogin for the user that I am trying to delete: SELECT dbo.umbracoUserLogin.* FROM dbo.umbracoUserLogin WHERE (userId = 13) and seems the database constraint is set on delete no action... is this by design?
Proposed Solution: Set on delete cascade for this particular database constraint. this basically means deleting a user will wipe off all of their login logs
Reference: Seems this is fixes in 8.9: https://github.com/umbraco/Umbraco-CMS/issues/9298
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.