Calendar Pro exceeding Host Resources

[Richard Linnett]

Hi,
I’ve had Events Calendar Pro on my site for a number of years. I renewed my license and updated the plugin a couple of weeks ago. Ever since my host (Hostgator) keeps suspending my entire reseller account (access to mysql databases) because of this website. It exceeds the server resources. I can only assume its the Pro plugin causing the issue.

Do you have any suggestions?
Gareth

[Courtney]

Hello Richard

Can you start by going through our Testing for Conflicts Guide https://theeventscalendar.com/knowledgebase/testing-for-conflicts/?  I am wondering if you might have a plugin or theme conflict.  Begin by deactivating all other plugins, using a theme such as Twenty Seventeen https://wordpress.org/themes/twentyseventeen/, and see if the issue still persists.

To review your server performance issues, we really need to take a peak at your System Info https://theeventscalendar.com/knowledgebase/sharing-sys-info/.

Also, double check for any other updates available (Dashboard » Updates). 

Please let me know if the issue still persists after these tests.

Thanks
Courtney 🙂

[Richard Linnett]

I’m struggling to test the site. I updated your plugins to the latest version again and used the ‘delete recurring events tool’. As soon as the site went live it exceeded the CPU quota and all my hosted websites (60+) lost database connections!
I’m 99% sure it’s an issue with your plugin. The issue occurred hours after updating to the latest release of Pro. Nothing else on the site changed.

I can not risk testing more fixes (plugin/theme conflicts). I can not have my entire reseller account go down again or risk Hostgator terminating my account.

At this stage I have deleted (via FTP) your plugins and hope the site will work again without issue. I’m forced to look for a new Events Calendar and start over.

My other concern is that although I’ve deleted the plugins, the database records still exist. Are you able to purge all Events Calendar records from the database.

Thanks,
Gareth

[Courtney]

Hi Richard

We do not have our own way to delete all events, but many customers have used https://wordpress.org/plugins/bulk-delete/ successfully.

We haven’t had other customers sharing this issue. Are any of your events lasting a very long time, like for years?

To help us troubleshoot, can you provide us with a database dump?  https://codex.wordpress.org/Backing_Up_Your_Database.  Please upload your file to Google Drive or something similar and send us a private reply with a link to download it.

I can then escalate your information on to our developers for more testing on this.

Thanks
Courtney 🙂

[Richard Linnett]

Hi,
Thanks for the reply.
I’ve read several Events Calendar Pro forum posts regarding excessive CPU usage. Also, the issue occurred hours after updating the plugin. So, I’m assuming its the cause.
This is a very simple WordPress site for a local running club.

We had 2 weekly recurring events on a Tuesday and Thursday. Yes these go on for years but I believe the settings option to show only for 12 months was set.
Also, I used the ‘cleanup recurring events tool’ and deleted all recurring events. The issue continued.

I’ve uploaded a database dump to the below link.
https://spaces.hightail.com/space/TbSv64u1DN
This dump is after the upgrade to the latest plugins and before deletion of the recurring events.

I’d love to continue using the plugin – it worked great for years and would save me re-inputting event on another platform. Any assistance would be great.

Thanks for your support.
Gareth

[Courtney]

Thanks Richard. I will escalate this issue for further testing. We definitely want to get this resolved soon.

Thanks
Courtney 🙂

[Courtney]

Hi Richard

When we test it out, there’s no discernible problem

The volume and distribution of events are not worrying in any way, any reliable host should be able to deal with this (unless there are complicating factors that we’re missing)

That suggests there are other factors, like theme code or other plugins getting in the way — or else the hosting environment simply lacks the ‘raw power’ needed.

Do you have a hosting account with a different provider (or perhaps you can trial one for a month) and see if you hit the same issues there.

Thanks
Courtney

[Richard Linnett]

Hi,
Thanks for the reply.
I am being forced to move the website to a new host as the site keeps taking down the server.
We are moving to Google calendars from now on. Do you know if there is a way to deactivate all records for your plugin from my existing database? Do I need to reinstall the plugins and delete via WordPress rather than ftp?

Gareth

[Courtney]

Hi Gareth

I’m so sorry to hear that. I do hope your next host is better equipped to handle your server load needs. We haven’t had this issue with other hosts nor any common complaints regarding this.

To thoroughly delete all data entered by our plugin, it will take some handy-work in your MySQL database.

This tutorial can guide you through deleting the content. https://www.w3schools.com/php/php_mysql_delete.asp

DELETE wp_posts
FROM wp_posts
INNER JOIN wp_postmeta ON wp_postmeta.post_id = dev_posts.ID
WHERE wp_posts.post_type IN (
'tribe_events',
'tribe_venue',
'tribe_organizer'
)


If this is a bit beyond your skills, going to Events and deleting all content from single events, venues, organizers, etc. will delete most all traces of our plugin in your database, then delete the plugins.

I’m sorry this has happened, and truly if we had a performance issue like this that was getting the same issue with even several other customers, we would certainly move to resolve it.

Thanks again
Courtney

[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