Can't delete users

Technical assistance
1

Hi,
when i try delete user with ruby console or directly from database i have a error:

SQL delete from “users” where “id” = ‘xxx’ failed : update or delete on table “users” violates foreign key constraint “fk_rails_e2a7142459” on table “roles_users”

What’s the problem?

2

What kind of user did you try to delete?

Please note that Zammad uses a database with references to different table locations.
This is, because Zammad is revision safe in first place. So if you delete a user, you also need to remove all tickets the user has. All references basically, otherwise you can’t remove the user.

Please provide more information as in

  • What database are you using?
  • What was the command you tried to run?
3

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.