cloudrck Posted March 10, 2014 Report Share Posted March 10, 2014 I have about 2K worth of spam tickets I need to close. I remember seeing a mysql query to close all open tickets. Can't seem to find it, does anyone know if off hand? Quote Link to comment Share on other sites More sharing options...
0 Ken Posted March 10, 2014 Report Share Posted March 10, 2014 This will mark all tickets in all departments closed. UPDATE `support_tickets` SET `status` = 'closed' Are you wanting to close them in a single department only? If so then you'll need to find the department ID in the 'support_departments' table and use the following. Where the number 1 is you'll need to change it to the department ID of choice: UPDATE `support_tickets` SET `status` = 'closed' WHERE `department_id` = '1' Michael and cloudrck 2 Quote Link to comment Share on other sites More sharing options...
0 Michael Posted March 10, 2014 Report Share Posted March 10, 2014 Not sure I just open a few and close them. You can use the plugin P.V made in the marketplace to do this with the tick boxes. Which is easier but when you update Blesta the function need to be re-added. Quote Link to comment Share on other sites More sharing options...
0 Ken Posted March 10, 2014 Report Share Posted March 10, 2014 (edited) Also I've not utilized this yet but perhaps this might be useful? http://www.blesta.com/forums/index.php?/topic/2001-support-manager-tickets-delete-merge-spam-multiple-tickets/ EDIT: Ahh it looks like you already have. Edited March 10, 2014 by Ken Quote Link to comment Share on other sites More sharing options...
0 cloudrck Posted March 10, 2014 Author Report Share Posted March 10, 2014 This will mark all tickets in all departments closed. UPDATE `support_tickets` SET `status` = 'closed' Are you wanting to close them in a single department only? If so then you'll need to find the department ID in the 'support_departments' table and use the following. Where the number 1 is you'll need to change it to the department ID of choice: UPDATE `support_tickets` SET `status` = 'closed' WHERE `department_id` = '1' That's it, thanks. I was too lazy to go through the database and figure this out myself. Also I've not utilized this yet but perhaps this might be useful? http://www.blesta.com/forums/index.php?/topic/2001-support-manager-tickets-delete-merge-spam-multiple-tickets/ EDIT: Ahh it looks like you already have. Yes, but I didn't want to go through 10 pages and delete tickets Ken 1 Quote Link to comment Share on other sites More sharing options...
Question
cloudrck
I have about 2K worth of spam tickets I need to close. I remember seeing a mysql query to close all open tickets. Can't seem to find it, does anyone know if off hand?
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.