wc-admin_import_orders fails randomly

  • Resolved alexqbox

    (@alexqbox)


    2 years, 5 months ago

    Hello,

    since some days the scheduled action wc-admin_import_orders fails randomly. So it works for like 50 orders and fails on 1. The order itself is created and i can see all the order data and customer data. I have no idea where the failed hook comes from or why.

    “Action marked as failed after 300 seconds. An unknown error has occurred. Check server, PHP and database error logs to determine the cause.”

    Do you have an idea? Thx

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Shameem – a11n

    (@shameemreza)

    2 years, 5 months ago

    Hi @alexqbox

    This could be due to various reasons, such as server timeouts, PHP errors, or database issues.

    The error message suggests that the action fails after 300 seconds, typically a sign of a server timeout. Here’s what you could do:

    1. Check your Server error logs. If there’s a PHP error causing the issue, it should be recorded here. This will also help identify if there’s a server configuration issue.
    2. Check your database error logs. If the database has a problem, it should be recorded here.

    If you’re unsure how to access these logs, please get in touch with your hosting provider. They should be able to assist you with this.

    Also, you might need to consider increasing the server’s max execution time, PHP time limit, PHP post max size and PHP max input vars. This can often solve issues related to server timeouts.

    Let us know how that goes. Looking forward to helping you.

    Thread Starter alexqbox

    (@alexqbox)

    2 years, 5 months ago

    Hi @shameemreza,

    after some days of checking the logs i can always see the same errors:

    [14-Dec-2023 13:33:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
    [14-Dec-2023 13:33:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
    [14-Dec-2023 13:33:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('action_scheduler_lock_async-request-runner', '657b04115b5cc6.36592740|1702560845', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
    [14-Dec-2023 13:33:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE wp_options SET option_value = '1705152785' WHERE option_name = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option

    Also this one is always repeating in the error log:

    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1605
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1606
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1607
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1608
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1617
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1617
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/themes/Avada/includes/lib/inc/class-fusion-woocommerce.php on line 172
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1605
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1606
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1607
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1608
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1617
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/woocommerce/includes/wc-template-functions.php on line 1617
    [14-Dec-2023 14:10:17 UTC] PHP Warning: Trying to access array offset on value of type bool in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/themes/Avada/includes/lib/inc/class-fusion-woocommerce.php on line 172

    Do you have an idea how to resolve it both? Thanks!

    xue28 (woo-hc)

    (@xue28)

    2 years, 5 months ago

    Hi @alexqbox

    From the error messages you’ve shared, it appears there are issues with your database commands being out of sync. This can occur if there is an attempt to run a new command while the previous one hasn’t finished executing.

    To resolve this, you may need to check your PHP code for any nested queries or commands that could be causing this conflict. Ensure that each database command is executed and completed before the next one starts.

    If you’re not comfortable with this, I would recommend reaching out to a developer or someone with technical knowledge in PHP and MySQL.

    Meanwhile, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

    • System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
    • Fatal error logs (if any) under WooCommerce > Status > Logs.

    You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

    Once we have more information, we’ll be able to assist you further.

    Thread Starter alexqbox

    (@alexqbox)

    2 years, 5 months ago

    Hi @xue28

    i know what you are talking about but obviously i can’t check the PHP Code of all installed Plugins belonging to Woocommerce. Also i can’t ensure that each database command is executed and completed before the next one starts. I mean how… it’s WordPress with Woocommerce and in total 38 Plugins installed.

    I am happy to share the logs with you and hope for further assistance to resolve the problem.

    Woo System Report:

    ` WordPress Environment

WordPress address (URL): https://urkornpuristen.de<br>Site address (URL): https://urkornpuristen.de<br>WC Version: 8.3.1<br>REST API Version: ✔ 8.3.1<br>WC Blocks Version: ✔ 11.4.9<br>Action Scheduler Version: ✔ 3.6.4<br>Log Directory Writable: ✔<br>WP Version: 6.4.2<br>WP Multisite: –<br>WP Memory Limit: 12 GB<br>WP Debug Mode: –<br>WP Cron: –<br>Language: de_DE<br>External object cache: – Server Environment

Server Info: LiteSpeed<br>PHP Version: 8.2.11<br>PHP Post Max Size: 2 GB<br>PHP Time Limit: 180<br>PHP Max Input Vars: 10000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w

SUHOSIN Installed: –<br>MySQL Version: 10.6.15-MariaDB-cll-lve<br>Max Upload Size: 1 GB<br>Default Timezone is UTC: ✔<br>fsockopen/cURL: ✔<br>SoapClient: ✔<br>DOMDocument: ✔<br>GZip: ✔<br>Multibyte String: ✔<br>Remote Post: ✔<br>Remote Get: ✔ Database

WC Database Version: 8.3.1<br>WC Database Prefix: wp_<br>Datenbank-Gesamtgröße: 651.53MB<br>Datenbank-Datengröße: 427.61MB<br>Datenbank-Indexgröße: 223.92MB<br>wp_woocommerce_sessions: Daten: 0.17MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_api_keys: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_downloadable_product_permissions: Daten: 0.02MB + Index: 0.04MB + Engine MyISAM<br>wp_woocommerce_order_items: Daten: 9.20MB + Index: 4.12MB + Engine MyISAM<br>wp_woocommerce_order_itemmeta: Daten: 110.71MB + Index: 71.33MB + Engine MyISAM<br>wp_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_actionscheduler_actions: Daten: 2.43MB + Index: 0.97MB + Engine MyISAM<br>wp_actionscheduler_claims: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_actionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_actionscheduler_logs: Daten: 2.00MB + Index: 1.32MB + Engine MyISAM<br>wp_alp_pickup_location: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_borlabs_cookie_consent_log: Daten: 13.24MB + Index: 2.29MB + Engine MyISAM<br>wp_borlabs_cookie_content_blocker: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_borlabs_cookie_cookies: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_borlabs_cookie_groups: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_borlabs_cookie_script_blocker: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_borlabs_cookie_statistics: Daten: 1.10MB + Index: 1.23MB + Engine MyISAM<br>wp_commentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_comments: Daten: 15.55MB + Index: 5.99MB + Engine MyISAM<br>wp_fusion_forms: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_fusion_form_entries: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_fusion_form_fields: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_fusion_form_submissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_litespeed_crawler_blacklist: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_litespeed_img_optming: Daten: 0.17MB + Index: 0.21MB + Engine MyISAM<br>wp_litespeed_url: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_litespeed_url_file: Daten: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_options: Daten: 9.14MB + Index: 1.02MB + Engine MyISAM<br>wp_pmxi_files: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_hash: Daten: 0.04MB + Index: 0.03MB + Engine MyISAM<br>wp_pmxi_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_images: Daten: 0.49MB + Index: 0.05MB + Engine MyISAM<br>wp_pmxi_imports: Daten: 0.48MB + Index: 0.00MB + Engine MyISAM<br>wp_pmxi_posts: Daten: 0.13MB + Index: 0.03MB + Engine MyISAM<br>wp_pmxi_templates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_postmeta: Daten: 95.86MB + Index: 40.30MB + Engine MyISAM<br>wp_posts: Daten: 22.13MB + Index: 2.57MB + Engine MyISAM<br>wp_pys_stat_landing: Daten: 0.14MB + Index: 0.00MB + Engine MyISAM<br>wp_pys_stat_order: Daten: 0.64MB + Index: 0.07MB + Engine MyISAM<br>wp_pys_stat_product_order: Daten: 8.26MB + Index: 0.27MB + Engine MyISAM<br>wp_pys_stat_traffic: Daten: 0.04MB + Index: 0.00MB + Engine MyISAM<br>wp_pys_stat_utm_campaing: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_pys_stat_utm_content: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pys_stat_utm_medium: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pys_stat_utm_source: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_pys_stat_utm_term: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_rtafar_rules: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_scalability_pro_cache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_shortpixel_folders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_shortpixel_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_shortpixel_postmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_smush_dir_images: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_storeabill_documentmeta: Daten: 16.05MB + Index: 8.29MB + Engine MyISAM<br>wp_storeabill_documents: Daten: 1.33MB + Index: 0.46MB + Engine MyISAM<br>wp_storeabill_document_itemmeta: Daten: 49.84MB + Index: 27.92MB + Engine MyISAM<br>wp_storeabill_document_items: Daten: 4.51MB + Index: 3.81MB + Engine MyISAM<br>wp_storeabill_document_noticemeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_storeabill_document_notices: Daten: 1.14MB + Index: 0.34MB + Engine MyISAM<br>wp_storeabill_journals: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_termmeta: Daten: 0.07MB + Index: 0.07MB + Engine MyISAM<br>wp_terms: Daten: 0.02MB + Index: 0.05MB + Engine MyISAM<br>wp_term_relationships: Daten: 0.07MB + Index: 0.14MB + Engine MyISAM<br>wp_term_taxonomy: Daten: 0.03MB + Index: 0.03MB + Engine MyISAM<br>wp_usermeta: Daten: 22.48MB + Index: 25.70MB + Engine InnoDB<br>wp_users: Daten: 1.52MB + Index: 0.41MB + Engine InnoDB<br>wp_wc_admin_notes: Daten: 0.05MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_admin_note_actions: Daten: 0.03MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_category_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_customer_lookup: Daten: 1.01MB + Index: 0.71MB + Engine MyISAM<br>wp_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_addresses: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_coupon_lookup: Daten: 0.02MB + Index: 0.05MB + Engine MyISAM<br>wp_wc_order_operational_data: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_order_product_lookup: Daten: 7.65MB + Index: 5.78MB + Engine MyISAM<br>wp_wc_order_stats: Daten: 1.75MB + Index: 0.90MB + Engine MyISAM<br>wp_wc_order_tax_lookup: Daten: 0.97MB + Index: 1.04MB + Engine MyISAM<br>wp_wc_product_attributes_lookup: Daten: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wp_wc_product_download_directories: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_product_meta_lookup: Daten: 0.02MB + Index: 0.03MB + Engine MyISAM<br>wp_wc_rate_limits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_reserved_stock: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wp_wc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wfls_role_counts: Daten: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wp_woocommerce_gzd_dhl_im_products: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_gzd_dhl_im_product_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_gzd_packaging: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_gzd_packagingmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_woocommerce_gzd_shipmentmeta: Daten: 6.48MB + Index: 2.34MB + Engine MyISAM<br>wp_woocommerce_gzd_shipments: Daten: 1.34MB + Index: 0.37MB + Engine MyISAM<br>wp_woocommerce_gzd_shipment_itemmeta: Daten: 8.47MB + Index: 6.71MB + Engine MyISAM<br>wp_woocommerce_gzd_shipment_items: Daten: 1.87MB + Index: 1.72MB + Engine MyISAM<br>wp_woocommerce_gzd_shipment_labelmeta: Daten: 3.50MB + Index: 2.36MB + Engine MyISAM<br>wp_woocommerce_gzd_shipment_labels: Daten: 0.59MB + Index: 0.26MB + Engine MyISAM<br>wp_woocommerce_gzd_shipping_provider: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_gzd_shipping_providermeta: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wp_woocommerce_shipping_table_rates: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wp_wpforms_tasks_meta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wpmailsmtp_debug_events: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wsal_metadata: Daten: 1.56MB + Index: 1.10MB + Engine MyISAM<br>wp_wsal_occurrences: Daten: 1.02MB + Index: 0.27MB + Engine MyISAM<br>wp_wt_iew_action_history: Daten: 0.30MB + Index: 0.00MB + Engine MyISAM<br>wp_wt_iew_cron: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wt_iew_ftp: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_wt_iew_mapping_template: Daten: 0.06MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_affiliates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_clicks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_commissions: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_yith_wcaf_commission_notes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_payments: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_payment_commission: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_payment_notes: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yith_wcaf_rate_rulemeta: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_yith_wcaf_rate_rules: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_yith_wcan_filter_sessions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yoast_indexable: Daten: 0.48MB + Index: 0.13MB + Engine MyISAM<br>wp_yoast_indexable_hierarchy: Daten: 0.02MB + Index: 0.06MB + Engine MyISAM<br>wp_yoast_migrations: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wp_yoast_primary_term: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_yoast_prominent_words: Daten: 0.36MB + Index: 0.60MB + Engine MyISAM<br>wp_yoast_seo_links: Daten: 0.83MB + Index: 0.14MB + Engine MyISAM Post Type Counts

at_checkout_ob: 1<br>attachment: 3641<br>avada_faq: 36<br>awb_off_canvas: 1<br>document_template: 5<br>fgf_master_log: 2129<br>fgf_rules: 2<br>fusion_element: 19<br>fusion_form: 1<br>fusion_icons: 1<br>fusion_tb_layout: 8<br>fusion_tb_section: 26<br>fusion_template: 5<br>gift_card: 196<br>nav_menu_item: 26<br>oembed_cache: 1<br>page: 22<br>post: 348<br>product: 72<br>product_variation: 188<br>revision: 510<br>shop_coupon: 243<br>shop_order: 22423<br>shop_order_refund: 246<br>wc_order_status: 13<br>wptb-tables: 21<br>yith_wcan_preset: 2 Security

Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (36)

ManageWP - Worker: von GoDaddy – 4.9.17<br>Erweiterte lokale Abholung für WooCommerce: von zorem – 1.6.0<br>FiboSearch - AJAX Search for WooCommerce: von FiboSearch Team – 1.26.1<br>Booster Plus for WooCommerce: von Pluggabl LLC – 7.1.4<br>Borlabs Cookie - Cookie Opt-in: von Borlabs GmbH – 2.2.67<br>Enable Media Replace: von ShortPixel – 4.1.4<br>Free Gifts for WooCommerce: von FantasticPlugins – 8.5<br>Avada Builder: von ThemeFusion – 3.11.3<br>Avada Core: von ThemeFusion – 5.11.3<br>Klarna Order Management for WooCommerce: von klarna<br>krokedil – 1.9.0

Klarna Payments for WooCommerce: von krokedil<br>klarna<br>automattic – 3.2.4

Komfortkasse für WooCommerce: von Komfortkasse Integration Team – 1.4.5<br>LiteSpeed Cache: von LiteSpeed Technologies – 6.0<br>Loco Translate: von Tim Whitlock – 2.6.6<br>One Stop Shop für WooCommerce: von vendidero – 1.4.0<br>PixelYourSite PRO: von PixelYourSite – 9.11.0.2<br>Product Catalog Feed Pro by PixelYourSite: von PixelYourSite – 5.4.1<br>Zahlungs-Plugins für PayPal WooCommerce: von Zahlungs-Plugins<br>[email protected] – 1.0.40

UpdraftPlus – Sichern/Wiederherstellen: von UpdraftPlus.Com<br>DavidAnderson – 2.23.14.0

vendidero Helper: von vendidero – 2.2.1<br>WPC Product Bundles for WooCommerce (Premium): von WPClever – 7.2.3<br>Germanized für WooCommerce Pro: von vendidero – 3.9.0<br>Germanized für WooCommerce: von vendidero – 3.15.3<br>WooCommerce Order Barcodes: von WooCommerce – 1.7.2<br>WooCommerce Order Status Manager: von SkyVerge – 1.14.0<br>WooCommerce Table Rate Shipping: von WooCommerce – 3.1.1<br>WooCommerce: von Automattic – 8.3.1 (Update auf Version 8.4.0 ist verfügbar)<br>Yoast SEO Premium: von Team Yoast – 20.8<br>Yoast SEO: von Team Yoast – 21.7<br>WP Mail SMTP: von WP Mail SMTP – 3.11.0<br>Smush Pro: von WPMU DEV – 3.12.1<br>WP Table Builder: von WP Table Builder – 1.4.13<br>Yoast SEO: WooCommerce: von Team Yoast – 15.7<br>YITH WooCommerce Affiliates Premium: von YITH – 3.1.0<br>YITH WooCommerce Ajax Product Filter Premium: von YITH – 4.28.0<br>YITH WooCommerce Gift Cards Premium: von YITH – 4.6.0 Inactive Plugins (2)

Import Export for WooCommerce Wrapper: von WebToffee – 1.1.5<br>Order Import Export for WooCommerce Add-on: von WebToffee – 1.1.1 Dropin Plugins (1)

advanced-cache.php: advanced-cache.php Settings

API Enabled: –<br>Force SSL: –<br>Currency: EUR (€)<br>Currency Position: right_space<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>gift-card (gift-card)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br>woosb (woosb)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)

Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ✔<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Shop-Basis: #520 - /mehl-kaufen-im-urkorn-shop/<br>Warenkorb: #585 - /warenkorb/<br>Kasse: #586 - /kasse/<br>Mein Konto: #587 - /mein-konto/<br>Allgemeine Geschäftsbedingungen: #7732 - /agb/ Theme

Name: Avada Child<br>Version: 1.0.0<br>Author URL: https://theme-fusion.com<br>Child Theme: ✔<br>Parent Theme Name: Avada<br>Parent Theme Version: 7.11.3<br>Parent Theme Author URL: https://themeforest.net/user/ThemeFusion<br>WooCommerce Support: ✔ Templates

Overrides: Avada/woocommerce/cart/cart.php<br>Avada/woocommerce/checkout/form-pay.php<br>Avada/woocommerce/checkout/review-order.php<br>Avada/woocommerce/loop/loop-start.php<br>Avada/woocommerce/single-product/add-to-cart/variable.php<br>Avada/woocommerce/single-product/short-description.php<br>Avada/woocommerce/single-product/tabs/additional-information.php<br>Avada/woocommerce/single-product/tabs/description.php Klarna Payments Request Log

2023-03-29 06:22:44: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[5].total_tax_amount\" ],\n \"correlation_id\" : \"31c1163e-99da-4d8e-b5f1-65af594fe1b9\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:22:43: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[5].total_tax_amount\" ],\n \"correlation_id\" : \"13091b46-ba4d-47aa-8654-473dd482d6ae\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:22:26: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[5].total_tax_amount\" ],\n \"correlation_id\" : \"c29bdd70-c59f-43e9-8a05-c6fcfa4c81f5\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:22:25: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[5].total_tax_amount\" ],\n \"correlation_id\" : \"550377d1-c474-4330-999e-ce65a70d85ca\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:22:25: KP Update Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[5].total_tax_amount\" ],\n \"correlation_id\" : \"4f957ea8-11ec-4dd5-a4f8-58b101040209\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:21:56: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"a2537b50-4daf-4ad8-876c-22a0a6f292e7\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:21:56: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"a07be9b2-b920-48df-a893-f4adc4098c47\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-29 06:21:56: KP Update Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"cca8128b-dbb0-4f1b-9ff9-49e8906db992\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:28:53: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[2].total_tax_amount\" ],\n \"correlation_id\" : \"27aaf87c-d6f0-42d7-ba2b-18d1d7951b3d\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:28:52: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[2].total_tax_amount\" ],\n \"correlation_id\" : \"c92a4b9f-50e8-4a81-9aae-62357c8e47e5\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:28:52: KP Update Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[2].total_tax_amount\" ],\n \"correlation_id\" : \"03a65985-67c7-4b7d-b33f-0b8d419b01b0\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:28:00: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"99157288-1e71-4243-bd7e-496b45ad02cf\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:27:59: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"5e3f1933-e0a0-4fcf-a777-8a37fc7bd855\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:27:59: KP Update Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"d517655b-747b-4450-b08e-f47fcd06c1ba\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID:

2023-03-28 16:26:43: KP Create Session<br>Response code: 400<br>Response message: {"headers":[],"body":"{\n \"error_code\" : \"BAD_VALUE\",\n \"error_messages\" : [ \"Bad value: order_lines[3].total_tax_amount\" ],\n \"correlation_id\" : \"4c7e2777-929c-4581-8808-074c04f2bb9e\"\n}","response":{"code":400,"message":"Bad Request"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}}<br>Correlation ID: Klarna Countries

Production Countries: DE<br>Test Countries: No countries selected Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-virtual-downloadable<br>product-external-affiliate<br>settings<br>async-product-editor-category-field

Daily Cron: ✔ Next scheduled: 2023-12-15 08:08:27 +01:00<br>Options: ✔<br>Notes: 101<br>Onboarding: completed Action Scheduler

Abgeschlossen: 9.674<br>Oldest: 2023-11-13 15:55:03 +0100<br>Newest: 2023-12-14 15:02:02 +0100

Ausstehend: 9<br>Oldest: 2023-12-15 03:00:00 +0100<br>Newest: 2023-12-18 14:00:04 +0100 Status report information

Generated at: 2023-12-14 15:24:50 +01:00<br>`

    Fatal errors log from today (the shortcode error is already reported to Avada Theme Support but shouldn’t be a reason. Also that feature is even disabled and not in use on the website)

    2023-12-14T07:40:17+00:00 CRITICAL Uncaught TypeError: array_merge(): Argument #1 must be of type array, bool given in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/fusion-builder/shortcodes/fusion-table-of-contents.php:509 Stack trace: #0 /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/fusion-builder/shortcodes/fusion-table-of-contents.php(509): array_merge() #1 /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/fusion-builder/shortcodes/fusion-table-of-contents.php(462): FusionSC_Table_Of_Contents::get_allowed_title_tags() #2 /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/fusion-builder/shortcodes/fusion-table-of-contents.php(436): FusionSC_Table_Of_Contents::sanitize_cache_trees() #3 /home/u169545354/domains/urkornpuristen.de/public_html/wp-includes/class-wp-hook.php(324): FusionSC_Table_Of_Contents::save_toc_tree() #4 /home/u169545354/domains/urkornpuristen.de/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #5 /home/u169545354/domains/urkornpuristen.de/public_html/wp-includes/plugin.php(517): WP_Hook->do_action() #6 /home/u169545354/domains/urkornpuristen.de/public_html/wp-admin/admin-ajax.php(203): do_action() #7 {main} thrown in /home/u169545354/domains/urkornpuristen.de/public_html/wp-content/plugins/fusion-builder/shortcodes/fusion-table-of-contents.php in Zeile 509

    There is nothing more in the fatal error log from today. But the PHP error log in my previous post is from today only and shows the errors.

    Thanks in advance

    xue28 (woo-hc)

    (@xue28)

    2 years, 5 months ago

    Hi @alexqbox

    I totally understand you here. I am referring to any custom code on your site if there’s any.

    For us to investigate this further, can you please try to switch to the default Storefront theme and only WooCommerce plugin is enabled and see if this works?

    If so, then this kind of problem is usually caused by your theme or a third-party plugin present on your site. We can run a conflict test to verify this. I’d recommend cloning your site to a staging environment and performing the tests described on this guide without modifying your live site or impacting customers. Many hosts provide staging facilities, so it’s worth checking in with them. It’s also possible to do it using the free WP Staging plugin.

    If this was caused by a third-party plugin present on your site, it would be best to reach out to the developers for further assistance here.

    Or, if you’d like someone else to do this work for you, our trusted partner, Codeable, has an offering where they will run this test for $150 USD. If there is time left, they will also fix the problems they found.

    Let us know how it goes!

    Thread Starter alexqbox

    (@alexqbox)

    2 years, 5 months ago

    Hi @xue28

    alright will do it and create a staging and run through the guide. If you can point out something regarding the log or system report i just shared it would be appreciated.

    The problem also appears very randomly and not even every day. But i can’t switch the theme on the live website to check it properly. The errors won’t show up instant but maybe some hours later. So that’s no solution for us.

    Thanks for the info about your partners. Will keep it in mind. I’ll let you know asap if i am able to resolve it.

    Thanks

    Plugin Support Shameem – a11n

    (@shameemreza)

    2 years, 5 months ago

    Hi @alexqbox,

    The database errors you’re seeing are usually due to a MySQL client trying to execute another command while fetching results from a previous command. This could be due to a plugin conflict or a database issue.

    As for the PHP warnings, they are typically non-fatal and don’t break the website’s functionality. They occur when you try to access an array offset on a value of type bool, which means the code is expecting an array but receiving a boolean value. This could be due to a recent update or a problem with the theme or plugin.

    And the last fatal error log you’ve shared indicates an issue with the fusion-table-of-contents shortcode, which is a part of the Fusion Builder plugin. The error message suggests that the plugin is trying to merge an array with a boolean value, which is causing a critical error.

    Even though you’ve mentioned that this feature is disabled and not in use on your website, it might still be causing issues if the plugin is active.

    As suggested by my colleague @xue28, a conflict test in a staging environment is the best way to isolate the issue.

    In the staging environment, you can switch to the default Storefront theme and disable all plugins except WooCommerce to see if the error still occurs. If it doesn’t, you can enable the other plugins individually to identify the one causing the conflict.

    If you need help setting a staging site, follow our detailed guide here: https://woo.com/posts/what-is-staging-site-wordpress-how-to-set-one-up/

    Also, contact your hosting provider and ask them to check for any issues with your database. They might need to repair it.

    Looking forward to your updates on the staging tests.

    Thread Starter alexqbox

    (@alexqbox)

    2 years, 5 months ago

    Hello @shameemreza

    I now have a staging site and could not reproduce the failed actions with 500 random test orders. I used this plugin https://ww.wp.xz.cn/plugins/generate-random-orders-for-woocommerce/ to create these orders. Besides the new test plugin, the same plugins are active as on the live site.

    But i see one main difference.

    The orders in my tests were all created via a wp-cron action and not via an asynch request. Also on the live website only the asynchronous requests fail randomly, not a single wp-cron action out of more than 10,000 actions.

    The failed actions are mostly related to wc-admin_import_orders but partly also to other hooks like woocommerce_gzd_shipments_label_auto_sync_callback (DHL shipping labels from Germanized). When I look at the orders in question, they all contain order data and there is no recognizable regularity, such as the same products or payment/delivery methods etc.

    Both I and the hoster (Hostinger) have checked the database for errors and also had it repaired, but without any errors. The problem persists.

    The cause seems to lie in the asynchronous requests. So wouldn’t it be possible to deactivate them completely and only use the server-side wp-cron? Is there anything against it, e.g. regarding payment providers or shipping? Could data be lost as a result?

    I have found the two PHP commands that I can place in the function.php of the child theme, but I am unsure which of the two or even both would disable the asynchronous requests.

    add_filter( 'action_scheduler_allow_async_request_runner', '__return_false' );
    add_filter( 'woocommerce_webhook_deliver_async', '__return_false' );

    The exact cause is still unclear to me as everything is running normally with the same active plugins and the more than 500 test orders on the staging site. I also have the Query Monitor active on the live site and will see if I can identify the exact cause of the failing asynchronous requests.

    For me, however, the obvious thing to do at the moment is to deactivate the asynchronous requests. Is there anything against it from your point of view?

    Why does woocommerce actually use wp-cron 90% of the time and asynchronous requests for the same hooks such as wc-admin_import_orders for about 10%. wc-admin_import_orders via wp-cron never fails, via asynch it does but completely randomly.

    Thanks in advance!

    Plugin Support Shameem – a11n

    (@shameemreza)

    2 years, 5 months ago

    Hello @alexqbox,

    Thank you for the detailed information and for setting up a staging site. It’s great to see you’ve been thorough in your testing.

    So wouldn’t it be possible to deactivate them completely and only use the server-side wp-cron? Is there anything against it, e.g. regarding payment providers or shipping?

    Yes, you can disable asynchronous requests and solely rely on server-side wp-cron. However, remember that this might slow down your site’s performance as wp-cron tasks are executed on every page load. This is why WooCommerce uses a mix of both wp-cron and asynchronous requests to balance performance and reliability.

    I have found the two PHP commands that I can place in the function.php of the child theme, but I am unsure which of the two or even both would disable the asynchronous requests.

    The two filters you’ve found will disable asynchronous requests. The action_scheduler_allow_async_request_runner filter disables Action Scheduler’s async runner, while the woocommerce_webhook_deliver_async filter disables async delivery of WooCommerce webhooks. You can add both to your child theme’s functions.php file to disable asynchronous requests.

    Could data be lost as a result?

    Disabling async requests shouldn’t result in data loss. However, it might delay the execution of some tasks, such as sending emails or processing orders, as these tasks will now have to wait for a wp-cron event to be triggered.

    Why does woocommerce actually use wp-cron 90% of the time and asynchronous requests for the same hooks such as wc-admin_import_orders for about 10%. wc-admin_import_orders via wp-cron never fails, via asynch it does but completely randomly.

    The reason why wc-admin_import_orders fails randomly could be due to server limitations or a conflict with another plugin. It’s hard to pinpoint the exact cause without further investigation. You could try increasing your server’s PHP memory limit or max execution time to see if that resolves the issue.

    I hope this clarifies your concern. Please let us know if you have any other questions!

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

The topic ‘wc-admin_import_orders fails randomly’ is closed to new replies.