List of events not showing in admin backend

[Jim Welch]

I no longer have a list of events showing in the Events backend, leaving me unable to delete events. Here’s a screenshot of the empty admin listing.

I think the problem was caused when, in an attempt to create an recurring event with an indefinite end date, I set the recurrence to end after 9999 events. This back-dated instances all the way to 1970! (please let me know if there’s a more elegant way to set an ‘indefinite’ end date — a scenerio I would consider very common for users). If it helps, the website’s event calendar is at http://www.oakgroveag.org/events.

I’m guessing with so many instances, the admin is “choking” and unable to render a list of events (for me to delete)???

How do I restore the listing of events in the backend? Or, can you suggest a way to delete all events from the database so I can start over again?

Thanks.

[Jonah]

Hi Jim,

This scenario certainly sounds like it would max out the system, if not our plugin, WordPress. How did you actually set the recurrence to end after 9999 events? I don’t think we have an option to set how many events to end it after or at least I wasn’t aware of one. You can do a custom recurrence and set it to re-occur every day/week/month/year but that only let’s you set it as far as 2023 in the future…

To clear out the events your best bet is probably to go into phpMyAdmin and run a delete query for all posts of post_type ‘tribe_events’. In the future I would suggest having a db backup so you can easily revert.

I hope that helps and let me know more detail on how you setup the recurrence.

Thanks,
Jonah

[Jim Welch]

Hi Jonah. Thanks for your reply. I had performed a db backup and I simply restored it to solve the problem. I was nervous to try and delete stuff directly from the database via phpMyAdmin b/c I have no experience with db queries and didn’t want to mess anything up.

[Rob]

Thanks for the follow-up, Jim, and for confirming as much. It sounds like based on your note you’re all set here now…right? Let me know if not and if you need anything else from us here. Otherwise I’ll close out this thread upon your confirmation. Cheers!

[Author]

Posts