- This topic has 16 replies, 3 voices, and was last updated 11 years ago by
.
-
Posts
-
After one of the last few upgrades all of my recurring events were duplicated. At one time there was 100s of thousands of events which brought the site to a crawl. I was able to get it working more smoothly by changing the recurring event setting to only 1 month instead of 12 months as it was before. This merely brought the number down to around 77,000. I installed the duplicates clean-up plugin (https://theeventscalendar.com/release-events-calendar-pro-3-5-2-hotfix/) and have run it a few times. It merges about 200 records before the page times out and I get a Page Not Found error. This is not efficient. Is there another way to clean up all of these duplicates? MySQL script?
Hi timadams,
Our apologies for the inconvenience, we realize this can be a real pain.
I’m afraid the plugin you’ve already located is the best existing tool for the job and yes, in extreme cases, you may need to run it multiple times to workaround the timeout issues.
Can I ask which versions of our plugins you updated from and to, here?
So I am going to have to run the plugin roughly 385 times? Seriously?!? It’s taking about 3 minutes to run each time so that means I’m going to have to sit clicking a button for 19.25 hours?!? It would be easier to blown away the whole thing and recreate the events. please let me know the best way to do that. My time is way too valuable to sit clicking s button.
I’m not certain exactly which upgrade cause the issue but I tend to stay pretty up-to-date on the plugin. I started noticing the duplicates after upgrading to 3.9 from the release just prior to that but I’m not entirely certain that the corruption wasn’t already there prior to that.
I completely sympathize.
What I’m going to do here is assign this topic to my colleague Brook who will work with you to try and find some other means of resolving this that doesn’t require such an arduous approach (but please do note there may be a slight delay beyond our normal response window before he can take this forward).
Thanks for your patience in the meantime 🙂
Howdy Timadams!
I wanted to give you an update. I am currently customizing the duplicate plugin a little bit. I am trying to come up with a work around to make it refresh automatically. It’s definitely a work around. But, it will prevent you from having to click refresh at all, so that is an obvious win. Most of our users were able to clear the database with only a refresh or two, and so it was not a big deal. But, your 385 is obviously a different matter so we are trying to craft a solution just for you.
I will have this ready for you either tomorrow or first thing Monday. Please let me know if you have any questions. Cheers!
– Brook
Hello again Timadams,
We have hacked together a solution for now that will be able to clean a database like yours without clicking refresh. We have also scheduled a rebuild of the cleanup plugin, so that it will automatically refresh on its own without needing a “hack”. But that will likely take a number of weeks to build.
To be honest, the current hack that I have is going to be a pain for you to setup. In light of that, would you be interested in exporting a copy of your WordPress database and sending it to support @ this website? Please reference this topic if you do that. I will get your database from the email, clean out all of the duplicates using my hack, then send it back to you. As you know the duplicate cleanup takes a while to run, so it could be a day or two before you get it back. Any changes you make to your website, such as new blog posts or comments, would be lost once you import the cleaned up database. Would that be a problem for you? Or would you prefer that method? I will happily do it if so, just send the database to that email address.
Does that all make sense? Would you prefer one method over the other? Whichever works for you works for me.
Cheers!
– Brook
- The topic ‘Recurring Events Duplicated’ is closed to new replies.