is it safe to delete tickets directly from the mysql db? meaning
change status to ‘delete’ from ‘new’? and then let RTx-Shredder do its
thing? we have a bunch of tickets that needs to be deleted (SPAM got
through) and there is not quick way of deleting them other than going
into the actual ticket setting status to deleted. is there a delete
link? like a take link?
It is safe to do this. Just don’t actually remove the ticket from the database.
I’ve had to do this in the past when I was initially moving our setup to a
new version of RT.
Keep up with me and what I’m up to: http://theillien.blogspot.com
slamp slamp wrote:
At Tuesday 6/26/2007 08:33 AM, slamp slamp wrote:
is it safe to delete tickets directly from the mysql db? meaning
change status to ‘delete’ from ‘new’? and then let RTx-Shredder do its
thing? we have a bunch of tickets that needs to be deleted (SPAM got
through) and there is not quick way of deleting them other than going
into the actual ticket setting status to deleted. is there a delete
link? like a take link?
It’s generally not safe to do updates directly to the database,
unless you have a thorough understanding of the schema - and it’s
very complex in places. As always I’d recommend learning how to write
Perl scripts that use the RT API.
But in this case, could you not use bulk update in the web interface
to delete a batch of tickets?
Steve