Scheduled Events

Sorry, I can’t help, but I’m curious, where/how do you see this?

Hi @fmh999,

This should be fixed as of version 2.0.6. I’m sorry this happened to your site.

Disconnecting and reconnecting should clear any duplicate entries. The others would need deleted with a MySQL query.

We used these two queries:

DELETE FROM wp_posts WHERE post_type='scheduled-action' AND post_title='wc_square_refresh_connection' AND post_status='pending' AND ID > 98354;
DELETE c FROM wp_comments c LEFT JOIN wp_posts p ON p.ID = c.comment_post_ID WHERE p.ID IS NULL

The first ID number references the first scheduled action so it leaves at least one of the scheduled action. If you want to remove all of them then that’s not necessary. The second query deletes orphaned comments after deleting the posts.
In theory though you could also just change the post_status from pending to trashed instead of deleting them. The cleanup routine will then catch them after 30 days.

As far as we have seen just reconnecting with 2.0.6 should be sufficient for most but let us know what you find.

So this plugin has added over 150,000 events to my WordPress site. Great ??

And it keeps adding it every minute even though I have disconnected from Square and deleted this plugin!

Hi,

So this plugin has added over 150,000 events to my WordPress site. Great ??

?hm ??

And it keeps adding it every minute even though I have disconnected from Square and deleted this plugin!

Then something else is holding on to the CRON / Action Scheduler events. If the plugin is gone there is not trigger or code to execute the tasks.

Have you tried the SQL query above?

**Before you do that, please do make a full backup!**

I ran the SQL queries and it deleted all the pending scheduled events however the CRON / Action Scheduler continues to run every minute adding new and then completed wc_square_refresh_connection

How can I stop this cron?

OKAY good news. ??

I ran the SQL queries mentioned above minus the POST ID as I wanted everything deleted.
It deleted all the pending “wc_square_refresh_connection” scheduled events thankfully.

I took it one step further and also deleted the completed “wc_square_refresh_connection” scheduled events.

It also seems like the cron has stopped adding new “wc_square_refresh_connection” thankfully.

After having done that I also optimized by database, I saw that this fantastic “wc_square_refresh_connection” hook bloated by SQL Database by 100 MB!

Thank you for your help!

My last question: if I re-install this plugin (which I am afraid to do), will this problem come back?

I have re-enabled this plugin and everything seems to be working properly now.
Thank you for your help.