Delete users but retain tickets

RickxZen

Hi everyone,

I was wondering if it was possible to delete users while retaining their closed tickets.

If I don't tick the 'Also delete all associated tickets and attachments' field I can't delete the user.

Using osTicket version 1.12.

ntozier

I believe that you would have to assign the tickets to another user before you can delete the User.

RickxZen

ntozier would it be possible to remove the users in the database without deleting the tickets?

ntozier

It's possible. But if you ever went to view the tickets after the fact you would break the site.

RickxZen

ntozier I created a user and wrote a query as following:

UPDATE ost_ticket SET user_id='513' WHERE user_id IN ('269','300')

513 is the new user and 269,300, etc. are the old users I want to remove.

This changed ownership of tickets to the new user and after this I removed the old users manually.

This fixed my issue.

ntozier

That's what I would have done. ?

KevinTheJedi

@RickxZen

In our system, in order to delete a User you must delete all tickets they own. This is because if you delete the User and not the tickets all their tickets will now have no link to a User and would disappear into thin air...this is not ideal. So, you either have to delete all associated tickets or change the owner of all associated tickets to a different User first.

Cheers.

RickxZen

KevinTheJedi Thanks for the explanation.