Jump to content

Deleting closed tickets


Tim H

Recommended Posts

We have about 50 thousand closed tickets that I am unable to delete using the normal process.  I'm talking about the one where you list all the closed tickets, then check the box at the top and press "delete" button.    When I do that, it asks if I'm sure I want to delete them, and then it doesn't delete them.   I've tried multiple times, closed it down, re-logged in, and tried again - also tried just deleting 5 - 10 tickets at a time but it won't do that either.   

The suggestion from WHMCS Support was this:   "You could do it programmatically using the DeleteTicket API: https://developers.whmcs.com/api-reference/deleteticket/.  I'd recommend writing up an SQL query and executing it through PHP using Capsule and query builder to select the ticket records you wish to delete, then loop through those and call the DeleteTicket API on each one to get it deleted.

Does anyone in the community have a better idea for how to get rid of them?  Thanks for any help you can provide. 

Tim

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated