Erase request

Serge_Torop · January 10, 2001, 7:32pm

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

Tobias_Brox3 · January 11, 2001, 7:46am

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.

Othmar_Pasteka · January 15, 2001, 10:16am

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

Tobias_Brox3 · January 15, 2001, 12:56pm

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.