Remove old/past (recurring) events

[Amazing Mixed Media Minds]

This concerns a WordPress Multisite which contains 4 subsites.
We need to clean-up old/past (recurring) events, what’s the best way to do this?

[Victor]

Hi There!

Thanks for getting in touch with us! Let me help you with this topic.

You can modify the “Delete recurring events after” option in Events > Settings to a very low number, like 1 month, and then save the change.

We also have a Recurring Event Cleanup Tool you can use > https://theeventscalendar.com/extensions/recurring-event-cleanup-tool/. Please note that you it is highly recommended that you make a backup of your database before doing so, just in case something goes wrong you can always restore your site. It can also be a good idea to test it out in a staging/dev site.

I hope that help! Let me know if you have any other questions.

Best,
Victor

[Amazing Mixed Media Minds]

Dear Victor,

Thanks for your reply.
We tested the Recurring Event Cleanup Tool, but this tool deletes every event except the first initial event.

I’ll try to describe what we are trying to do.
We want to cleanup the database by deleting all old/past Events and recurring Events, like before a certain date. So we tried, your suggestion for the recurring events, to set the “Delete recurring events after” to 2 months, but in our Multisite are so many recurring events the (staging/dev)server dies.

Maybe there is a database query we could try to clean the database? Please advise,

Patrick Thomassen
Amazing BV

[Victor]

Hi Patrick!

Thanks for following up with this.

I understand now what you are trying to accomplish. We have a feature request to build a functionality that will allow exactly that > https://tribe.uservoice.com/forums/195723-feature-ideas/suggestions/11732886-delete-past-events Please do add your vote there.

We don’t currently have a database query to accomplish that. The only workaround to this I can think of is using the recurring event clean up tool to delete all the instances and then edit the recurring event to re-create the instances by adjusting the dates and series setting.

It might not be ideal if you are dealing with too many recurring events as you’ll have to go for each of them, but it will allow you to overcome the problem with your server.

I hope that helps. Let me know if you have any follow up question.

Best,
Victor

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts