Sync Doesn’t Work

  • Resolved Anonymous User

    (@anonymized-23173868)


    1 year ago

    The product sync on my site is not working. Getting errors such as this in the log…

    [01-May-2025 14:20:53 UTC] WordPress database error Commands out of sync; you can’t run this command now for query SELECT * FROM wp_posts WHERE ID = 1876 LIMIT 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Post_Data::do_deferred_product_sync, array_walk, WC_Post_Data::deferred_product_sync, WC_Product_Variable::sync, WC_Product->save, WC_Data_Store->update, WC_Product_Data_Store_CPT->update, WC_Product_Data_Store_CPT->update_post_meta, WC_Data_Store_WP->update_or_delete_post_meta, update_post_meta, wp_is_post_revision, wp_get_post_revision, get_post, WP_Post::get_instance

    [01-May-2025 14:23:51 UTC] PHP Warning: foreach() argument must be of type array|object, null given in /home/example/public_html/wp-content/plugins/woocommerce-square/includes/Sync/Product_Import.php on line 730

    How do I fix this so that the sync actually works?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Anonymous User

    (@anonymized-23173868)

    1 year ago

    I’m seeing this error in the Action Scheduler page for the “wc_square_job_runner” event. It’s failing.

    action marked as failed after 1200 seconds. Unknown error occurred. Check server, PHP and database error logs to diagnose cause.

    Mahfuzur Rahman

    (@mahfuzurwp)

    1 year ago

    Thanks for sharing those details, that’s super helpful.

    The errors you’re seeing suggest a couple of things going wrong during the sync process:

    1. “Commands out of sync” typically points to a MySQL issue — often caused by unclosed queries or timing issues in how data is being processed during shutdown actions.
    2. The foreach() warning means WooCommerce Square is expecting data that isn’t being returned properly — likely due to the sync process breaking earlier.
    3. The Action Scheduler failure (with wc_square_job_runner) indicates the job is timing out or hitting a server resource limit (like PHP max execution time or memory).

    Here’s what I recommend:

    • Check server limits: Make sure your hosting environment allows enough memory and execution time for long-running tasks. You can ask your host to increase values like max_execution_time and memory_limit.
    • Clear stuck actions: Go to WooCommerce > Status > Scheduled Actions, filter for Failed, and try to manually delete any wc_square_job_runner actions stuck there.
    • Enable debugging logs: If not already active, turn on WP_DEBUG_LOG in your wp-config.php to capture more detailed errors.
    • Update everything: Make sure WordPress, WooCommerce, and the Square plugin are all updated to the latest versions.

    If the issue continues, please feel free to share a copy of your System Status Report and any relevant error log under WooCommerce > Status > Logs. You could copy and paste it via https://gist.github.com/ and send the link here.

    Let us know how it goes!

    Plugin Support Kay U a11n

    (@kingsleyinfo)

    1 year ago

    We haven’t heard back from you in a while, so I’m going to mark this as resolved.

    If you have a few minutes, we’d love if you could leave us a review: https://ww.wp.xz.cn/support/plugin/woocommerce-square/reviews/

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Sync Doesn’t Work’ is closed to new replies.