Deleting a ticket

[Hybrid]

Hi all,

We had a problem with our helpdesk which made it panic and start looping tickets. The result, we have a 92 page, 462 reply ticket which fails to delete in the normal manor.

Can anyone think of a way to delete this ticket as our database is now massive.

Many thanks.

[Hybrid]

A bit more info for you.

This is the result when we try to delete in the normal manor...

Invalid SQL: SELECT `ticketwordid` FROM `swticketwords` WHERE `contents` IN ('tutor','2','not','working','in','inclusion','roo m','new','reply','tutor','2','not','working','in', 'inclusion','room','ticket','status','tutor','2',' not','working','in','inclusion','room','new','stat us','closed','old','status','needs','rebuilding',' ticket','details','','ticket','id','bkn-273216','department','general','priority','urgent' ,'status','needs','rebuilding','httpwwwstbffindexp hp_mtickets_aviewticketticketid76','ticket','detai ls','','ticket','id','bkn-


Running windows 2000 and the latest build of e-support if thats any more help to you.

[supportskins]

These 2 queries should delete the ticket and ticket post:

DELETE from swtickets where ticketid = TICKETNUMBER;
DELETE from swticketposts where ticketid = TICKETNUMBER;

Here TICKETNUMBER is the precise number -- example 1,2,330, etc. Hope this helps.

Note: This ticketid is different from what you receive in the emails (XYZ-12345).

[Hybrid]

Sorry to be a bit stupid this morning but where you mention ticketnumber. Where do i find that out?

Is it the e-mailed number? BKN-273216

Or is it just simply 273216?

Many thanks.

[eiden]

The ticketnumber is the Id of the ticket. You can find it by viewing the ticket and read the ticketid= parameter in the URL.