Not syncing orders

Hi there, it looks like you may have a stalled Action Scheduler in WordPress which processes jobs for WooCommerce. The Action Scheduler isn’t part of the plugin per se, but here’s a few step you can to take to troubleshoot Action Scheduler issues:

1. Identify Stalled Queues: A clear sign of a stalled Action Scheduler is when you have pending jobs that are newer than the last completed jobs, often by an hour or more. This situation indicates that the queue isn’t processing any tasks, and actions are getting backed up.
2. Test by Running a Single Job: When you suspect the scheduler is stalled, you can manually run a task to see if it runs successfully. Here’s how:
   • Navigate to the WordPress admin dashboard.
   • Go to ‘Tools’ and then ‘Scheduled Actions’.
   • Filter the list to show ‘Pending’ tasks.
   • Select a single pending task and click ‘Run’ to execute it manually.
   • Observe if the task runs successfully.
3. Diagnose the Cause of a Stalled Scheduler: If manually running a task is successful, but tasks are not being processed automatically, it suggests that the scheduler itself isn’t running. You can try the following troubleshooting steps:
   • Check WP-Cron Configuration: Ensure that WP-Cron, the system WordPress uses for handling scheduled tasks, is correctly configured and not disabled.
   • Deactivate Plugin Conflicts: Temporarily deactivate other plugins to rule out conflicts that might be preventing the Action Scheduler from running.
   • Verify Server Resources and Configuration: Make sure that the server has the necessary resources and configurations to handle the cron jobs, especially if there’s a high volume of scheduled tasks.
   • Consult Hosting Support: Contact your hosting provider’s support to check for any server-side restrictions or configurations that may affect cron jobs.
4. Preventive Measures and Regular Checks: To avoid future issues with the Action Scheduler, you can:
   • Regularly monitor the ‘Scheduled Actions’ section to catch any buildup of pending tasks early.
   • Establish routine checks and database cleanup to ensure the Action Scheduler operates smoothly.

If you continue to experience issues with the Action Scheduler, it’s recommended to reach out to WooCommerce support or consult with a developer for further assistance.

Thanks for getting back to me.

I can see that WP-Cron is working. No error in woocommerce status. I ran the pending ones and they all completed fine. I can see that there are lots of failed Mailchimp ones.

MailChimp_WooCommerce_Single_OrderFailed ‘obj_id’ => 23242 action failed via WP Cron: Call to a member function get_type() on bool

I tried a resync again and this came back with MailChimp_WooCommerce_Process_Full_Sync_Manager – action marked as failed after 300 seconds. Unknown error occurred. Check server, PHP and database error logs to diagnose cause.

Thanks

Hi there, thanks for the note back. It’s good to know that WP-Cron is functioning correctly and that other WooCommerce tasks are completing as expected. However, the errors with Mailchimp tasks you’ve encountered point towards issues that might be specific to the Mailchimp for WooCommerce plugin’s interaction with your site’s environment or the data being processed.

The MailChimp_WooCommerce_Single_OrderFailed error, indicating a call to a member function get_type() on a boolean, suggests that the plugin is attempting to act on an order that, for some reason, it cannot properly reference or access. This could be due to a variety of reasons, such as data inconsistencies, transient communication issues between your site and Mailchimp, or specific configurations in your WooCommerce setup that are not standard.

The action marked as failed after 300 seconds error during a full sync operation further suggests that there might be limitations or restrictions in your server’s configuration that are preventing long-running tasks from completing. This can often be related to PHP execution time limits, memory limits, or database server timeouts.

Here are some additional steps you can take to diagnose and hopefully resolve these issues:

1. Check Server and PHP Logs: Look into your server’s error logs, as well as the PHP and database error logs, for any entries that coincide with the times you attempted to sync or when you know a failure occurred. These logs may provide more specific details on what is failing and why.
2. Increase PHP Limits: If not already done, try increasing the PHP max_execution_time and memory_limit values in your php.ini file. For example, setting max_execution_time to 300 (seconds) or higher and memory_limit to 256M or more can help with long-running processes.
3. Examine Failed Tasks Detail: Within the WordPress admin, navigate to ‘Tools’ > ‘Scheduled Actions’, and filter to show ‘Failed’ tasks. Look for any failed actions related to Mailchimp and note if there’s a pattern or specific orders causing repeated failures.
4. Update Plugins and Themes: Ensure that both WooCommerce and Mailchimp for WooCommerce plugins are updated to their latest versions. Compatibility issues can arise from outdated versions, leading to unexpected errors.
5. Debugging Mode: Consider enabling WordPress’s debugging mode by setting WP_DEBUG to true in your wp-config.php file. This might reveal more details about the underlying issue but should be used cautiously on a live site.
6. Consult with a Developer: If the issue persists and you’re not comfortable making these changes yourself, or if the logs don’t offer clear insights, it might be worth consulting with a 3rd party developer who has experience with plugins. They can offer a more hands-on investigation into your site’s specific configuration.

Hi @jammerw, we just wanted to check back with you to see if this was still a problem for your site. Please let us know when you get a moment.

Hi @khungate, Thanks for all the info. It looks like I found a plugin (Booster for Woocommerce) that was causing a problem with it. I have disabled the plugin and seems to be working, although I do still get some failed in the Action Scheduler when orders are updated. Usually down to “action marked as failed after 300 seconds. Unknown error occurred. Check server, PHP and database error logs to diagnose cause.”

@jammerw I would first check your “fatal error logs” to see if there’s any error logs that would be more helpful than the generic “check your logs” messages you’re seeing. Maybe there’s something in that log that would point us in the right direction.

If it’s failing after 300 seconds, that could be for many reasons and it’s just about impossible for us to know what that is from our current position, but the one thing that it could very well be is the need to upgrade a server, or your database to account for more traffic. I’m not sure what you’re currently working with but moving from shared databases and servers to a dedicated server is always a logical first step if you haven’t yet.

Would it be feasible for you to do a little more digging into your fatal logs and report back?

Hi there, we’re going to close out this ticket for now since it’s been a few weeks since we’ve been in touch.

Please let us know if you still need any help and we’ll be glad to reopen and troubleshoot further. Please note, that the best way to reach us is over at the GitHub plugin page: https://github.com/mailchimp/mc-woocommerce/. From there, you can receive direct responses from the development team, log new issues, download the latest version, and track existing support tickets.