My Events Page is taking forever to load after the recent update

[Robert]

Hello,

I just recently updated KidRips.com with the new Events Calendar and Events Calendar PRO plugins and now the site it taking forever to load (and sometimes just timing out all together). Do you have a solution for this?

Please advise.. We need to resolve this issue immediately. We are using the Event Calendar on another site and there’s not issues there. This is the only site to use the Events Calendar PRO.

Please let me know what’s going in.

[Cliff]

Hi Robert. Sorry to hear you’re experiencing this.

I visited http://kidrips.com/ and it loaded quickly. No hangups. Then I went to http://kidrips.com/events/ and it’s a 404 error so I don’t know about the affect of the update on your site from my browser.

I haven’t heard of this happening elsewhere.

Please follow our Testing for Conflicts Guide and see if that helps narrow down the cause of this.

Let us know what you find out.

Thanks.

[Robert]

I had to completely disable the plugin in order to get the site to load. It was crippling our server. Our client said that they have copied and pasted a lot of the event information from PowerPoint and Word? Would that affect the plugin?

I’ve uninstalled it and reinstalled it and it still won’t work? I’ve got it running on two other sites with no issue.

Please let me know what to do to fix this issue.

Thanks,

Rob

[Robert]

OK, after further review it looks like the recurring event is contstatnly duplicating forever. Right now I have over 32,000 events all of the same type. How to I stop this replication?

[Robert]

What is the simplest way to remove all of the erroneous entries.

[Cliff]

Good find! (And sorry that’s happening)

I’ve seen this a few times when people create recurring events and then put something invalid in the recurrence settings.

Like http://cl.ly/2z3e1w3H2m07, it should be a number, but sometimes people put something like “until 7/20/2016”, which might be getting interpreted as 7,202,016 times! (a bug we’ve got logged)

Maybe you can search your database and look in your postmeta table for potentially offending entries?

[Robert]

Right, but how so I stop it. I’ve “Updated All” for the page to change it to 12 times, but I still have 32,000 + entries in my Events database.

How can I remove all of these entries… It’s bogging down our entire site.

[Robert]

It’s still trying to process the 1,012,017 entries…I can’t stop that process even though I’ve update the event listing.

[Cliff]

Hi Robert. One of our developers said something like this might work for your situation:

add_filter( 'tribe_events_pro_recurrence_small_batch_size', '__return_zero' );

Please let me know how things go for you…

[Robert]

I assume that I add this to my child “functions.php” file. Please advise?

[Robert]

I added that code, but it’s still showing 32,000 events in the backend. I need a way to remove the 31,585 duplicates from the database. Please let me know what’s the easiest way to accomplish this.

[Cliff]

Robert, I’m glad it stopped creating new events in the recurrence series.

If you’re able to, you can delete them via the Events wp-admin screen (bulk select, trash, empty trash).

If you choose to go that route, you’d probably want to change your Screen Options (top right corner of Events wp-admin screen) to display more than 20 events (maybe 100 or even 250).

However, if you’re unable to or don’t want to do it via this method, you could find all the post IDs and run wp_delete_post() on them.

===

You might want to reference these resources:

Snippet: https:// gist.github.com /cliffordp/71a343dd9956b1303dee#file-events_with_recurrence-php (without the spaces in the URL)

Possibly https://codex.wordpress.org/Function_Reference/get_children

I hope this info helps! 🙂

Please let me know.

[Robert]

Unfortunately, this is not ideal. I can’t delete more than 20 at a time without WordPress timing out. I’m trying to use the Event Rocket plugin to delete all of the entries, and even that hangs up. There should be an option within the plugin to remove all events.

I’ve managed to get it down to 17,000.. but its still taking forever. This is a nightmare.I can’t believe it’s so difficult to remove all of the events.

What is the name of the database table that stores the events. I’m going to try and manually delete them using phpMyAdmin.

[Cliff]

You should add some code in functions.php to leverage wp_delete_post() instead of deleting via PHPMyAdmin because there are several database tables affected (posts, post meta, terms).

Do you want to delete ALL of The Events Calendar’s posts/events?

If yes, you can reference this snippet (untested!):

Here: https://gist.github.com/cliffordp/ee148004b0d8a429095a

Please let me know how things go for you.

[Robert]

This also times out… As soon as I upload this “functions.php” to the Child Theme folder, the site won’t load and I only get the “white screen of doom”…

Man, who would’ve thought that it would be so difficult to remove events.. I have to say, I’m severely disappointed in your product. I’ve wasted the past 3 days trying to remove these events. And I still have over 6,000 erroneous events remaining.

This is even more frustrating because the PRO recurring event system tried to add over 1 million events. You should change the wording if you don’t want people to use dates in that field.

This product stinks… but now I’m stuck using it until I can remove these final 6,000 events.

I can’t believe that you don’t have a way to just clear the database of all of the EVENT data…

UUUUUGGGGGGHHHHHHHHHHH!!!!!!!!

[Author]

Posts