Erase request


#1

Hi,

How can I delete useless requests from database
at all? For example: delete all “dead” requests.

Or drop request counter to zero?

Thanx to advance.

Serge P. Torop
St.Petersburg, Russia


#2

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
script.

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
request ids.

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


#3

Hi,On Thu, Jan 11, 2001 at 08:46:37AM +0100, Tobias Brox wrote:

In RT1, the requests should be deleted from the database when they are
killed. Anything else is a bug.

how can i kill requests through the webui? or is this just with
the cli and/or mailgateway possible?

so long
Othmar


#4

how can i kill requests through the webui? or is this just with
the cli and/or mailgateway possible?

Simply by setting the status to ‘dead’ from the ticket status view. IIRC.

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