- Used Zammad version: 3.4
- Used Zammad installation source: package
- Operating system: Ubuntu 18.04
- Browser + version: Chrome 83
I installed Zammad and then I created my users (Agents) who logged in and tested the system (created organization, test tickets, etc).
Later, I added Google Authentication for logging in also (as we are G Suite customer - I restricted the Google Auth log into our domain only). I also asked our users to link their existing accounts with Google from Profile settings.
But before going live I discovered that the users are able to login with either Google Auth OR with existing local credentials. My aim is to allow my users to login ONLY with Google Auth, so I deleted all existing users of my Organization and asked them to sign up using Google directly. Before they signed up, I deleted all the relevant users using console with command:
Since Zammad has only been used for testing up till now, I have also deleted all tickets from console with command
The only problem is one of the users is not getting deleted with this command. I get the error:
> ActiveRecord::InvalidForeignKey (PG::ForeignKeyViolation: ERROR: update or delete on table “users” violates foreign key constraint “fk_rails_edec76c076” on table “organizations”)
DETAIL: Key (id)=(15) is still referenced from table “organizations”.
: DELETE FROM “users” WHERE “users”.“id” = $1
I have followed all steps from this post here but still I get the same error.
- Delete specific user
- Cannot delete user
Steps to reproduce the behavior:
- Not sure if this can be reproduced.
Thanks in Advance