- Edited
I was creating test tickets, when I was having some other issues and the "Thank You" page wasn't going through.This created an error in the system, where it interpreted it as though a new ticket had been generated, but when you went into the "Open" tickets queue, they weren't there.I went to delete the duplicate user account that was generated as well, with the error, but it was not allowing me to delete the user saying that I couldn't because the user had a ticket.I 100% made sure I my team, group, department, and myself (agent) had all the permissions to delete users/tickets; had "Full Access" to everything and was administrator and I still couldn't delete the user.So I went into PHPMyAdmin and deleted the user manually from the database (I made a backup before-hand just in case!).Tested, everything is fine; user is gone etc.However, now in my Agent Panel page, I'm stuck with a 'ghost' ticket in "My Tickets"; see picture below:As you can see, there is only ONE actual ticket in the queue or in "My Tickets" but the display number is saying otherwise.I think the database still thinks that glitched user/ticket that was generated during the error is still in there.Does anyone know, where in the MySQL database this number is affected or where this "ghost" ticket would be located?Also, when deleting a user manually from the MySQL database, e.g. through PHPMyAdmin, do you have any advice as to other entries that should be deleted alongside that user?That is, if I were to delete a non-glitched user from osTicket via the Admin/Agent interface; do you know what the PHP script tells the MySQL database to delete? That way I can make sure I follow the same procedure should something like this happen again and not leave ghost entries in the database.FYI:In the database I navigated to:-ost_user ost_user I found the duplicate glitched user and deleted the entry from that table.Now I see there is also: ost_user__cdataI deleted the entries in there based on a cross reference to the phone # I have of the test users in osTicket. Got rid database entries associated to the phone numbers that weren't tied to any user account/profile.