Not Syncing

@sedagems, thanks for reaching out. Just to get a handle on the situation you’re experiencing, could you provide a few more pieces of information to help us understand the issue?

– What is your PHP memory limit is set to?
– Is there any logging errors in the plugin’s logs tab (when it’s set to standard or debug)?
– Do you have any caching plugins or services running?
– Have you tried a fresh uninstall or reinstall?

Thanks in advance for these details. I’ll keep an eye out for your reply.

– Kyle

Thanks for replying @khungaate

– PHP memory limit is 256MB
– No errors, only “2018-07-31T12:41:10+00:00 NOTICE sync.started :: Starting Sync :: Tue, Jul 31, 2018 2:41 AM”
– I disabled W3 Total Cache a few days go to see if that caused an issue. I am still running the site through cloudflare though
– Yes I have done full uninstalls and reinstall with no change

Thanks for the info. @sedagems, can you temporarily disable the cache in Cloudflare and try a fresh uninstall & reinstall? Lastly, who is your hosting provider?

Hi @khungate

I disabled Cloudflare, deleted the plugin and let it sit for a few hours.

Installed the plugin again and I still get the same issue.

My hosting provider is “The search engine shop”, but I am not exactly sure who they use for the actual hosting

Hi @sedagems, thanks for trying that out. Can you ask with your hosting provider if they might be blocking access to the admin-ajax.php file on your WordPress install?

Hello

I have confirmed with my host that they are not blocking access to the admin-ajax.php file.

The hosting provided has said “if you’re comfortable we could give them a developer logon to look directly?”

At this stage I a willing to pay for assistance to get this up and running

Hi @sedagems, thanks for letting us know. Also, I meant to ask this earlier – do you have the latest version of the plugin (2.1.9) running on PHP 5.6 or higher?

I am running PHP 7.0.31-1 and version 2.19

@khungate I have done some more investigating over the weekend

1 – I took a full copy of my website and installed it on a new shared server through crazy domains
2 – I still could not get it to sync
3 – I deleted every user, product and order, so now I only have 1 user, 1 product and 1 order to sync
4 – I check the wp_queue and it has:
O:38:”MailChimp_WooCommerce_Process_Products”:10:{s:9:”*action”;s:38:”mailchimp_woocommerce_process_products”;s:40:”MailChimp_WooCommerce_Abstract_Syncapi”;N;s:39:”MailChimp_WooCommerce_Abstract_Syncmc”;N;s:48:”MailChimp_WooCommerce_Abstract_Syncplugin_name”;s:21:”mailchimp-woocommerce”;s:11:”*store_id”;s:0:””;s:26:”should_kill_queue_listener”;b:0;s:11:”WP_Jobjob”;N;s:13:”WP_Jobdelay”;i:0;s:15:”WP_Jobdeleted”;b:0;s:16:”WP_Jobreleased”;b:0;}

5 – I have switched over to a standard theme, deleted all other plugins so only woocommerce and the mailchimp plugins are active

@sedagems ok that brand new installation probably needs to see some traffic to get the queue to operate correctly. You might need to set up a 3rd party uptime monitor for your site that pings the domain every minute to simulate traffic. The queue system just needs a little nudge – which can easily be done with either refreshing the page, site visits or an uptime monitor – anything that would simulate a page view should do the trick.

My guess is that if you were to be refreshing the main site page a few times, the job would complete.

After you give this a try – please check your MailChimp plugin logs to see if you see anything meaningful ( any activity )

Hi

I sent lots of traffic to my webpage but the queue didn’t change.
The log didn’t show anything, so I manually did a &resync=1 and got this in the logs:
2018-08-07T09:52:13+00:00 NOTICE sync.started :: Starting Sync :: Mon, Aug 6, 2018 11:52 PM
2018-08-07T09:57:47+00:00 NOTICE sync.started :: Starting Sync :: Mon, Aug 6, 2018 11:57 PM

Is there a way I can get the queue to manually work?
Could it be the same problem on my original website that the queue is working correctly?

@ryanhungate or @khungate, I checked the wp-admin/admin-ajax.php file as you mentioned in another thread and it returned a white page with a 0.

Have you got any other ideas on how to get this plugin to work.
As I said before am more than happy to pay to get this thing working now and I wold be happy to give you any logins to my site and hosting that you need

@sedagems can you reach out to me directly ( [email protected] )? We can take a peek into what’s going on. Assuming that you have SSH access to your server? Whatever your host said they could do might be of help – but don’t send that information here – send it to me privately.

Thanks @ryanhungate, email sent ??

@sedagems thanks for the follow up. Since I had responded to you personally, I wanted to add the final solution here so other folks can see.

There was a non expiring http_worker_lock site transient which was causing the queue system to stay in a paused state. We use something called a http_worker_lock to prevent duplicate processes running – and somehow this particular transient record didn’t have an expiring timestamp. The solution was to delete that lock record.

Once I ran this below – everything synced up perfectly:

delete_site_transient( 'http_worker_lock' );

We will need to add a UI enhancement to the plugin in our next build to do this for people in this situation – and it will most likely solve a lot of the questions about being stuck ??

Thanks again for working through this with us!
Ryan