deleted department - where are the tickets (recover tickets)

[nocare]

hi folks,

i use the supportsuite owned at last stable version.

my question:
if i delete a department, where are the tickets gone? they are still in db but i cannot access them via web interface. is there an posibillity to access them after the deletion of a department?

thanks for your responses.

[rickowen]

They will be in the DB, you can run an sql query to change them to the department you want.
You will have to find the correct depart id in the db then use that number for the dept for the ticket

we use phpmyadmin do do this

cheers

Richard

[eiden]

Here is the SQL-query:
UPDATE swtickets SET departmentid = [new departmentId] WHERE departmentId = [old departmentid]

[nocare]

Originally Posted by eiden

Here is the SQL-query:
UPDATE swtickets SET departmentid = [new departmentId] WHERE departmentId = [old departmentid]

perfect job! thanks.

[Giray]

Originally Posted by eiden

Here is the SQL-query:
UPDATE swtickets SET departmentid = [new departmentId] WHERE departmentId = [old departmentid]

Hi. I have the same problem and want to make sure I do it right. I don't use the square brackets, right. So it would be (for example):

UPDATE swtickets SET departmentid = 8 WHERE departmentId = 12

No commas missing, no brackets??
Thanks

[eiden]

That's correct.

You replace the brackets with your own values.

[craigbrass]

Hmm, didn't realise this happened when you deleted a department. It should ask you if you want to :-
1. Delete the tickets.
2. Move them into another department.

when deleting a department.

Jamie: maybe move this to feature requests?

[Giray]

Quite surprising when it happened, actually. No warning whatsoever and I 'lost' about a thousand tickets. Now going back in to try to recover, but...