[rt-users] Erase request
tobiasb at suptra.org
Thu Jan 11 02:46:37 EST 2001
> How can I delete useless requests from database
> at all? For example: delete all "dead" requests.
In RT1, the requests should be deleted from the database when they are
killed. Anything else is a bug.
Eventually you'll first have to take out all the dead request ids:
select serial_num from requests where status='dead';
Then delete everything from the transactions and the tickets table
reffering to those requests. It's pretty easy to do through a shell
> Or drop request counter to zero?
That's not a good idea, it might produce clashes between old and new
requests. Besides, I think it's impossible without deleting the whole
database. RT uses the mysql auto_increment feature for increasing the
If you need further help, I will be located in spb from ~23th of January.
Tobias Brox | +47 98660706 | Freelance consulting:
Bestumvn 35 | NO 982 763 134 | Linux, Programming, Web services,
N-0281 Oslo | NOK to 9731.58.18099 | Support Tracking, Distributed Systems
More information about the rt-users