Upgrade to 3.5.2 Broke + Thousands of Duplicates

[Jason]

I recently updated a client site from Pro 3.4 to 3.52 and two things happened:

– WP-Admin started throwing off 500 Internal Server Errors
– All of the recurring events duplicated thousands of times

I’ve reverted back to 3.4, but all of the recurring event duplicates are still there. I tried using the plugin you wrote to delete the duplicates, but after clicking the option one time, it no longer appears – and the dupes are still there.

How can this be handled? We now have 6,000 duplicate events (and I can’t even get to “Screen Options” to try and get more of them on the screen at the same time – that’s broken) and still can’t update to 3.5.2.

Please help. Guys, this is really upsetting. We even tried bringing back the old Tribe Events posts for the calendar from a backup and it was a total failure.

[Casey D]

Hello jungermedia,

Thanks so much for waiting patiently. I remember your tweets from yesterday, we’ve just been swamped.

I’ll do my best to get this resolved soon, although ugly issues like this sometimes take more time.

If you have a database back up that is the fastest and most obvious solution.

Where are we sitting right now?

– Can you login to the admin?
– Do you still have 6000 duplicates? I see one particular recurring event called Upper Room Prayer & Counseling, but I think that is intentional.
– What is your host/server configuration? The bug appears because of a mysql time out on smaller machines with too many events.
– Do you have a developer/staging instance somewhere? It might be better to do this upgrade on a non-production site

Ultimately, (while ugly) this is a relatively simple problem to solve, we just need to clean up the database.

To fix this, we need to do these steps, as you’re aware

– Install and activate The Events Calendar Pro 3.5.2
– Install and activate the cleanup plugin
– Run clean up plugin multiple times until the duplicates are gone

Let me know where you are stuck right now and we’ll troubleshoot from there.

Thanks again for your patience!

– Casey Driscoll

[Jason]

Hey Casey –

I did have a backup, but for some reason it didn’t capture the latest records from our e-commerce store (more important to the client) – so that’s another story.

I was able to get into admin by deleting a plugin called “Login Lockdown.” Not sure if it’s a coincidence or a real incompatibility, but FYI.

After that, I was able to run the clean up plugin. It timed out every time, but about 50 refreshes later, it got rid of the dupes.

[Casey D]

Hello jungermedia,

Happy it worked out!

Sorry again for the delays. I’ll go ahead and close this thread. Let us know if we can help with anything else.

– Casey Driscoll

[Author]

Posts