Runaway Recurring Events

[Brian]

Having the same issue with one recurring event going out of control 26,000 occurences. Locking up my site where I can’t perform backups, site performance is slow, etc.

I tried step one of this process and can not see any results…

Here is the procedure to follow:

Using phpMyAdmin, run the following SQL script: https://gist.github.com/elimn/a998d7b67f6166dab5e17ec071eb35ee – this will likely return 1 or maybe 2 event IDs that have the runaway recurrence issue
Edit/update those event IDs in WP Admin. This can usually be accomplished by adding a space to end of the event description and hitting update. This will cause it to rebuild the recurrence and remove the offending entries.
If that does not work, then you can use the following SQL script to delete all recurrence of any event id: https://gist.github.com/elimn/e5de5d2037678de0b926c307022571c5

If I privately send you my login credentials, can you help me clean this up?

Many Thanks For the GREAT Plugin!

Brian

[Brook]

Howdy Brian,

I would love to help you with this.

I bet the lack of results you are seeing is because your database is using a different prefix than the default one.

To make this even easier, and remove the  need to worry about prefixes, I just wrote this cleanup tool: tribe-extension-recurring-cleanup-v0-1-0 It is a plugin you can download install on your website. Once activated you will see a new tool in WP Admin > Tools > Available Tools. It will show you a list of all of your current recurrences, sorted by those which have the most recurrences. It will also show you the ID for each.Follow the steps outlined in the tool to then delete all recurrences for that event. Here is an example of what the tool looks like:

Does that all make sense? Did that tool work for you? Please let me know.

Cheers!

– Brook

[Brian]

WOOHOO! It worked! Thanks so much!

[Brook]

Splendid news! Thanks for getting back Brian.

• Brook

[Author]

Posts