cannot delete event series

[victoria bell]

http://www.littlepaper.com

an event series has gone mad, multiplying until I have 17,500+ occurrences.

i start on the page as in the attachment
i click edit series and I am returned to the same page
i click edit event and i am returned to the same page

i don;t have the patience or time to hand delete 17,500 events

🙁

what can i do?

thanks – vicki

[victoria bell]

and i forgot – when i click on the event in the calendar itself, I get a page not found error

[Geoff B.]

Good evening Vicki and welcome back!

Thank you for reaching out to us.

We are sorry to hear about the recurring event going out of control on your website. Yikes!
I would love to help you with this topic.

As a first troubleshooting step, could you please provide us with your complete system information in a private reply using the instructions found in the following link?

https://theeventscalendar.com/knowledgebase/sharing-sys-info/

Provided you have the latest version of our plugins (4.2.3), there are a couple of options available to fix this:

1. Simply re-saving the parent event should rebuild the recurrences (it might take a while provided the number, but that should work)
2. We have a snippet to help trigger the rebuild manually: recurrence-rebuild-helper
3. We also have an SQL query that will delete all of the recurrences of the events (so that you can rebuild them quicker). But that requires some comfort with phpMyAdmin

Let me know if that helps.

Have a great day!

Geoff B.

[victoria bell]

This reply is private.

[victoria bell]

This reply is private.

[Geoff B.]

Good evening Victoria,

Thank you for writing back.
I am sorry to hear that you can’t edit the faulty events or at least re-save them.

The first thing I would try is to deactivate and reactivate your the Events Calendar Pro plugin.
The first going being to stop the events ongoing creation.

The second thing to do is to install the plugin contained in the previous link in your plugins folder.

Once that is done, you will need to activate it.

Let’s see how that goes first before attempting phpMyAdmin attempts.

Let me know how that goes.

Best regards,
Geoff B.

[victoria bell]

This reply is private.

[Eric]

What is the phpmyadmin SQL command? I’m having the same problem and it’s making me nuts.

[victoria bell]

by which i mean i deinstalled, installed, activated and re-activated with no love… what’s next

[Geoff B.]

Good afternoon Victoria,

I am sorry that this hasn’t worked out for you yet. Same goes to @eric.

It might be that there is something blocking WP Cron on your installs.

In any case, before running the SQL query, please make sure you have backed up your Database and that you are able to revert back to it if anything goes south.

So here is the query: https://gist.github.com/GeoffEW/e750ef07aae1d1eff45178031ee64c25

Once that’s done, you will have to re-save your recurring events to generate proper recurrence rebuild.

Let me know how that goes.

Best regards,
Geoff B.

[victoria bell]

This reply is private.

[Geoff B.]

This reply is private.

[victoria bell]

This reply is private.

[Geoff B.]

Good afternoon Vicki,

Congratulations on getting this far.

You are almost there! The error message is because you have included “*/” in the query.

The actual query to use should look like:

delete a,b,c,d
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id )
LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id )
LEFT JOIN wp_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id )
LEFT JOIN wp_terms e ON ( e.term_id = d.term_id )
WHERE a.post_parent = 12421

Let me know how that goes.

Best regards,
Geoff B.

[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