Ticket stuck, can't delete

[Dids]

Hey guys,

 

so, I've got a ticket that seems to be stuck so that I can't see it when I go through all the tickets (all open, closed, etc.) but on the dashboard (and on my iPhone) I can clearly see there's one ticket just idly sitting somewhere.

 

Do I need to delete this directly from the database? If so, would someone kindly point me at the right table and such?

 

Thank you in advance!

[WHMCS John]

Please ensure your admin account is assigned to all the support departments.

 

All tickets can be found in the database in tbltickets so you can check that the ticket is assigned to a support department (the did value).

[Dids]

Please ensure your admin account is assigned to all the support departments.

 

All tickets can be found in the database in tbltickets so you can check that the ticket is assigned to a support department (the did value).

 

Thanks, got it.

 

It was actually a spam email stuck in the tickets that I couldn't see or access through WHMCS.

 

I emptied the whole ticket table via: TRUNCATE `tbltickets` ;