WooCommerce Orders Imports get stuck and WooCommerce Error Message
-
Hi there,
When I try to import some WooCommerce Orders it is getting stuck sometimes on 6% on a CSV file with about 900 orders. When I spoke to my hosting company they said that they could see a WooCommerce Error at the same time which is probably causing it.
The full support message:
Thanks for the info, I’ve just checked the site logs and am seeing the following fatal error from the Woocommerce plugin repeated
PHP message:PHP Fatal error: Uncaught Error: Call to undefined method ActionScheduler_DBLogger::unhook_stored_action() in /www/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/Runner.php:99
Does anyone know what is causing this and how to fix this issue?
Many thanks.
-
Hi @tallmale
Thanks for reaching out!
As a first step, can you please share your System Status Report, that will help us further troubleshoot.
You can find it via
WooCommerce > Status
. SelectGet system report
and thenCopy for support
. Once you’ve done that, you can paste it into your reply here.### WordPress Environment ### WordPress address (URL): https://wacky-orchard.flywheelsites.com Site address (URL): https://wacky-orchard.flywheelsites.com WC Version: 7.0.1 REST API Version: ? 7.0.1 WC Blocks Version: ? 8.5.2 Action Scheduler Version: ? 3.4.0 Log Directory Writable: ? WP Version: ? 6.0.3 - There is a newer version of WordPress available (6.1) WP Multisite: – WP Memory Limit: 300 MB WP Debug Mode: – WP Cron: ? Language: en_GB External object cache: – ### Server Environment ### Server Info: Flywheel/5.1.0 PHP Version: 8.1.12 PHP Post Max Size: 300 MB PHP Time Limit: 300 PHP Max Input Vars: 10000 cURL Version: 7.68.0 OpenSSL/1.1.1f SUHOSIN Installed: – MySQL Version: 5.7.38-google Max Upload Size: 300 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? ### Database ### WC Database Version: 6.2.1 WC Database Prefix: wp_nzq4msmrep_ Total Database Size: 490.14MB Database Data Size: 297.50MB Database Index Size: 192.64MB wp_nzq4msmrep_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_woocommerce_order_items: Data: 1.52MB + Index: 1.52MB + Engine InnoDB wp_nzq4msmrep_woocommerce_order_itemmeta: Data: 41.58MB + Index: 15.06MB + Engine InnoDB wp_nzq4msmrep_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_actionscheduler_actions: Data: 1.52MB + Index: 0.84MB + Engine InnoDB wp_nzq4msmrep_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_actionscheduler_logs: Data: 1.52MB + Index: 0.23MB + Engine InnoDB wp_nzq4msmrep_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_booking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_bookingdates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_commentmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_comments: Data: 17.55MB + Index: 11.09MB + Engine InnoDB wp_nzq4msmrep_cpappbk_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_cpappbk_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_db7_forms: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_ditty_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_ditty_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dividebuy_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_dopbsp_api_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_availability: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_dopbsp_availability_no: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_dopbsp_availability_price: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_dopbsp_calendars: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_nzq4msmrep_dopbsp_coupons: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_days: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_nzq4msmrep_dopbsp_discounts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_discounts_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_discounts_items_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_emails: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_emails_translation: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_extras: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_extras_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_extras_groups_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_fees: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_forms_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_forms_select_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_languages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_locations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_models: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_reservations: Data: 0.02MB + Index: 0.14MB + Engine InnoDB wp_nzq4msmrep_dopbsp_rules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_searches: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_settings_calendar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_settings_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_settings_payment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_settings_search: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_smses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_smses_translation: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_dopbsp_translation_en: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_dopbsp_woocommerce: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_nzq4msmrep_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB wp_nzq4msmrep_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wp_nzq4msmrep_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_nzq4msmrep_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_followup_customers: Data: 1.52MB + Index: 1.44MB + Engine InnoDB wp_nzq4msmrep_followup_customer_carts: Data: 17.55MB + Index: 0.97MB + Engine InnoDB wp_nzq4msmrep_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_followup_customer_orders: Data: 0.45MB + Index: 0.30MB + Engine InnoDB wp_nzq4msmrep_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_followup_email_logs: Data: 1.52MB + Index: 0.42MB + Engine InnoDB wp_nzq4msmrep_followup_email_orders: Data: 3.52MB + Index: 1.00MB + Engine InnoDB wp_nzq4msmrep_followup_email_tracking: Data: 0.30MB + Index: 0.48MB + Engine InnoDB wp_nzq4msmrep_followup_followup_history: Data: 0.22MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_followup_order_categories: Data: 0.38MB + Index: 0.53MB + Engine InnoDB wp_nzq4msmrep_followup_order_items: Data: 0.47MB + Index: 0.70MB + Engine InnoDB wp_nzq4msmrep_followup_subscribers: Data: 0.14MB + Index: 0.14MB + Engine InnoDB wp_nzq4msmrep_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_gf_entry: Data: 3.52MB + Index: 0.72MB + Engine InnoDB wp_nzq4msmrep_gf_entry_meta: Data: 21.55MB + Index: 27.64MB + Engine InnoDB wp_nzq4msmrep_gf_entry_notes: Data: 0.22MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_gf_form_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_gf_form_view: Data: 0.38MB + Index: 0.31MB + Engine InnoDB wp_nzq4msmrep_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_hustle_modules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_hustle_modules_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_mec_attendees: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_mec_bookings: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_mec_dates: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_mec_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_mec_occurrences: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_mec_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_mphb_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_mphb_sync_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_mphb_sync_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_mphb_sync_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_mphb_sync_urls: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_nextend2_image_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_nextend2_section_storage: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_nextend2_smartslider3_generators: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_nextend2_smartslider3_sliders: Data: 0.19MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_nextend2_smartslider3_sliders_xref: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_nextend2_smartslider3_slides: Data: 0.30MB + Index: 0.11MB + Engine InnoDB wp_nzq4msmrep_ngg_album: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_ngg_gallery: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_ngg_pictures: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_options: Data: 8.50MB + Index: 0.22MB + Engine InnoDB wp_nzq4msmrep_postmeta: Data: 63.58MB + Index: 46.14MB + Engine InnoDB wp_nzq4msmrep_posts: Data: 13.52MB + Index: 3.67MB + Engine InnoDB wp_nzq4msmrep_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_redirection_items: Data: 0.08MB + Index: 0.09MB + Engine InnoDB wp_nzq4msmrep_redirection_logs: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_revslider_css: Data: 0.13MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_revslider_css_bkp: Data: 0.13MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_revslider_layer_animations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_revslider_navigations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_revslider_sliders: Data: 0.13MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_revslider_slides: Data: 1.52MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_revslider_slides_bkp: Data: 0.25MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_revslider_static_slides: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_shortpixel_folders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_shortpixel_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_shortpixel_postmeta: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_nzq4msmrep_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_tablesome_records: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_tablesome_table_49889: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_term_relationships: Data: 0.17MB + Index: 0.16MB + Engine InnoDB wp_nzq4msmrep_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_tinvwl_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_tinvwl_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_new_plugin: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_answers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_dbt: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_id: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_iminqu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_iminqu_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_iminqu_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_iminqu_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_impoll: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_impoll_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_impoll_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_impoll_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_imwibu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_imwibu_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_imwibu_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_imwibu_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_inform: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_quest_im: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_results: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stpoll: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stpoll_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stpoll_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stpoll_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stwibu: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stwibu_01: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stwibu_02: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_totalsoft_poll_stwibu_1: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_usermeta: Data: 28.56MB + Index: 26.09MB + Engine InnoDB wp_nzq4msmrep_users: Data: 2.52MB + Index: 1.50MB + Engine InnoDB wp_nzq4msmrep_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wc_admin_note_actions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wc_customer_lookup: Data: 1.52MB + Index: 0.80MB + Engine InnoDB wp_nzq4msmrep_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_wc_order_coupon_lookup: Data: 0.16MB + Index: 0.23MB + Engine InnoDB wp_nzq4msmrep_wc_order_product_lookup: Data: 1.52MB + Index: 1.02MB + Engine InnoDB wp_nzq4msmrep_wc_order_stats: Data: 1.52MB + Index: 0.88MB + Engine InnoDB wp_nzq4msmrep_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wc_product_meta_lookup: Data: 0.13MB + Index: 0.27MB + Engine InnoDB wp_nzq4msmrep_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_wfconfig: Data: 0.52MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wffilemods: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfhits: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_wfknownfilelist: Data: 10.52MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wflogins: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_nzq4msmrep_wfpklist_template_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB wp_nzq4msmrep_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_woel_woocommerce_order_emails_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wplc_chat_msgs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wplc_chat_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wplc_offline_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wplc_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wsal_metadata: Data: 22.56MB + Index: 36.25MB + Engine InnoDB wp_nzq4msmrep_wsal_occurrences: Data: 11.52MB + Index: 6.03MB + Engine InnoDB wp_nzq4msmrep_wsmea_conditional_payment_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_wtbp_tables: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_nzq4msmrep_yoast_indexable: Data: 2.52MB + Index: 1.02MB + Engine InnoDB wp_nzq4msmrep_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.05MB + Engine InnoDB wp_nzq4msmrep_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_nzq4msmrep_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_nzq4msmrep_yoast_seo_links: Data: 0.30MB + Index: 0.19MB + Engine InnoDB wp_nzq4msmrep_yoast_seo_meta: Data: 0.34MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### attachment: 619 blocked_user: 4 custom_css: 4 display_type: 7 ditty: 1 ditty_display: 3 ditty_layout: 3 dt_portfolio: 15 dt_team: 9 dt_testimonials: 9 elementor_icons: 1 elementor_library: 48 et_pb_layout: 9 follow_up_email: 8 nav_menu_item: 217 oembed_cache: 10 page: 54 post: 66 product: 879 product_variation: 162 revision: 1157 rl_gallery: 2 scheduled-action: 2 schema: 2 shop_coupon: 171 shop_order: 8632 shop_order_refund: 67 sln_attendant: 1 sln_booking: 20 sln_service: 6 tablesome_cpt: 1 testimonial: 3 testimonial_rotator: 1 wc_eatt_files: 1 wc_order_email: 41 wc_order_status: 61 wcp_ruleset: 4 wp_block: 2 wpcf7r_action: 1 wptb-tables: 9 ### Security ### Secure connection (HTTPS): ? Hide errors from visitors: ? ### Active Plugins (57) ### Gravity Forms: by Gravity Forms – 2.6.7 Admin Columns Pro: by AdminColumns.com – 5.6.4 Classic Editor: by WordPress Contributors – 1.6.2 Code Snippets: by Code Snippets Pro – 3.2.1 Conditional Payments for WooCommerce Pro: by Lauri Karisola / WooElements.com – 2.3.0 Disable Emails: by WebAware – 1.8.1 The7 Elements: by Dream-Theme – 2.7.1 Duplicate Page: by mndpsingh287 – 4.4.9 Elementor Pro: by Elementor.com – 3.7.7 Elementor: by Elementor.com – 3.8.0 Essential Addons for Elementor: by WPDeveloper – 5.4.2 Pixel Cat Lite: by Fatcat Apps – 2.6.6 Gravity Forms Polls Add-On: by Gravity Forms – 3.9 Gravity Forms Signature Add-On: by Gravity Forms – 4.3 Gravity Forms Survey Add-On: by Gravity Forms – 3.7 Happy Elementor Addons: by weDevs – 3.7.1 Head, Footer and Post Injections: by Stefano Lissa – 3.2.5 Health Check & Troubleshooting: by The www.remarpro.com community – 1.5.0 Hide Page And Post Title: by Arjun Thakur – 1.5.6 Klarna Order Management for WooCommerce: by klarna krokedil – 1.7.0 Klarna Payments for WooCommerce: by krokedil klarna automattic – 2.12.1 Smart Slider 3 Pro: by Nextend – 3.5.1.11 One-Click Child Theme: by tychay – 1.6 Perfmatters: by forgemedia – 1.9.9 Redirection: by John Godley – 5.3.4 Responsive Lightbox & Gallery: by dFactory – 2.4.1 Sliced Invoices: by Sliced Invoices – 3.9.1 Accept Stripe Payments: by Tips and Tricks HQ wptipsntricks – 2.0.70 Styles & Layouts Gravity Forms: by Sushil Kumar – 4.3.8 Swap Google Fonts Display: by WP Speed Matters – 1.1.1 Temporary Login Without Password: by StoreApps – 1.8.0 The7 CLI: by Dream-Theme – 1.0.0 User Role Editor: by Vladimir Garagulya – 4.63.1 WordPress Version Info: by alpipego – 1.2.1 Converter for Media: by Image Optimization Team by matt plugins – 5.3.1 WooCommerce Fraud Prevention Plugin: by theDotstore – 2.1.2 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.8.0 Woo Partial.ly: by Partially Inc – 2.1.17 WooCommerce Customer/Order/Coupon CSV Import Suite: by SkyVerge – 3.10.4 Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.6.5 WooCommerce E-Mail Attachments (by Inoplugs): by InoPlugs – 3.0.9 Follow-Up Emails: by WooCommerce – 4.8.7 WooCommerce GoCardless Gateway: by WooCommerce – 2.4.9 WooCommerce Stripe Gateway: by WooCommerce – 6.9.0 WooCommerce Gravity Forms Product Add-Ons: by Lucas Stark – 3.3.5 WooCommerce Order Status Manager: by SkyVerge – 1.9.3 WooCommerce Product Dependencies: by SomewhereWarm – 1.2.7 Dreamfox Media Payment gateway per Product for Woocommerce: by Dreamfox – 3.2.1 Sequential Order Numbers for WooCommerce: by SkyVerge – 1.9.7 WooCommerce Shipment Tracking: by WooCommerce – 1.6.11 WooCommerce Shortcodes: by WooThemes Claudio Sanches – 1.0.0 WooCommerce Uploads: by WP Fortune – 1.4.1 WooCommerce: by Automattic – 7.0.1 Wordfence Security: by Wordfence – 7.7.1 WordPress Importer: by wordpressdotorg – 0.8 WP Activity Log for WooCommerce: by WP White Security – 1.4.4 WP Activity Log: by WP White Security – 4.4.2.1 ### Inactive Plugins (7) ### Flexy Breadcrumb: by PressTigers – 1.2.1 Klarna On-Site Messaging for WooCommerce: by krokedil klarna – 1.8.0 No Gutenberg - Disable Block Editor - Back to Classic Editor: by Fernando Tellado – 1.0.12 Pixel Manager for WooCommerce: by SweetCode – 1.25.1 Redirection for Contact Form 7: by Qube One – 2.7.0 Slider Revolution: by ThemePunch – 6.5.25 WooCommerce Twilio SMS Notifications: by SkyVerge – 1.12.0 ### Dropin Plugins (1) ### db-error.php: db-error.php ### Must Use Plugins (1) ### Health Check Troubleshooting Mode: by – 1.8.0 ### Settings ### API Enabled: ? Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: – ### WC Pages ### Shop base: #54358 - /shop/ Basket: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block. Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block. My account: #53092 - /my-account/ Terms and conditions: ? Page not set ### Theme ### Name: Fab Smile Veneers Child Theme Version: (update to version 0 is available) Author URL: Child Theme: ? Parent Theme Name: The7 Parent Theme Version: 11.0.3 Parent Theme Author URL: https://dream-theme.com/ WooCommerce Support: ? ### Templates ### Overrides: dt-the7/woocommerce/cart/cart.php version 3.8.0 is out of date. The core version is 7.0.1 dt-the7/woocommerce/cart/cross-sells.php dt-the7/woocommerce/cart/mini-cart.php dt-the7/woocommerce/checkout/form-billing.php dt-the7/woocommerce/checkout/form-checkout.php dt-the7/woocommerce/checkout/form-coupon.php version 3.4.4 is out of date. The core version is 7.0.1 dt-the7/woocommerce/checkout/form-login.php dt-the7/woocommerce/checkout/form-shipping.php dt-the7/woocommerce/checkout/review-order.php dt-the7/woocommerce/checkout/thankyou.php dt-the7/woocommerce/content-product.php dt-the7/woocommerce/content-widget-product.php dt-the7/woocommerce/content-widget-reviews.php dt-the7/woocommerce/global/breadcrumb.php dt-the7/woocommerce/global/form-login.php version 3.6.0 is out of date. The core version is 7.1.0 dt-the7/woocommerce/global/quantity-input.php dt-the7/woocommerce/loop/loop-end.php dt-the7/woocommerce/loop/loop-start.php dt-the7/woocommerce/loop/pagination.php dt-the7/woocommerce/myaccount/form-login.php version 6.0.0 is out of date. The core version is 7.0.1 dt-the7/woocommerce/notices/error.php dt-the7/woocommerce/notices/notice.php dt-the7/woocommerce/notices/success.php dt-the7/woocommerce/order/order-details-customer.php dt-the7/woocommerce/order/order-details.php dt-the7/woocommerce/single-product/meta.php dt-the7/woocommerce/single-product/price.php dt-the7/woocommerce/single-product/related.php dt-the7/woocommerce/single-product/up-sells.php dt-the7/woocommerce/content-product_cat.php Outdated Templates: ? Learn how to update ### Klarna Payments Request Log ### 2022-08-17 11:22:17: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:22:17: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:21:43: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:21:41: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:21:40: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:21:39: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:21:39: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:21:28: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:20:47: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:20:45: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:20:45: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:20:24: KP test credentials Response code: 401 Response message: Correlation ID: 2022-08-17 11:18:49: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:18:14: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: 2022-08-17 11:18:12: KP Create Session Response code: 401 Response message: {"headers":[],"body":"<html><head><title>401 Authorization Required<\/title><\/head><body><center><h1>401 Authorization Required<\/h1><\/center><\/body><\/html>","response":{"code":401,"message":"Unauthorized"},"cookies":[],"filename":null,"http_response":{"data":null,"headers":null,"status":null}} Correlation ID: ### Klarna Countries ### Production Countries: GB Test Countries: No countries selected ### Admin ### Enabled Features: activity-panels analytics coupons customer-effort-score-tracks experimental-products-task experimental-import-products-task experimental-fashion-sample-products experimental-product-tour shipping-smart-defaults shipping-setting-tour homescreen marketing multichannel-marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: minified-js new-product-management-experience settings Daily Cron: ? Next scheduled: 2022-11-04 13:02:07 +00:00 Options: ? Notes: 97 Onboarding: completed
Hello @tallmale,
Thank you for sharing the report.
Seems like you have a heavily customised site. Before advising you to go with a full conflict test, I will recommend you do the following:
- Update both the WooCommerce plugin itself and the database.
- Increase the memory limit to 512MB (Ask your host to help with this).
Let us know how it goes!
Hi there,
Both the WooCommerce core plugin and the database have been updated as requested and the hosting company have increased the memory limit to 512 MB for 24 hours as requested so we can see if it helps.
Hello @tallmale Sure, take your time and let us know how that goes!
Hi Amir it has not helped and has not fixed the problem.
Hi @tallmale
I understand that after updating WooCommerce core and its database as well as increasing the memory limit, the error still persists.
Can you please re-share again your System Status Report as it is
incomplete? The part about Action Scheduler like the one below is not listed.### Action Scheduler ### Complete: 363 Oldest: 2022-10-13 08:31:09 +0800 Newest: 2022-11-12 14:45:09 +0800 Pending: 3 Oldest: 2022-11-13 11:00:00 +0800 Newest: 2022-11-13 14:24:30 +0800
Thanks!
Hi there,
I managed to find a solution myself but using another plugin by WebToffee. This issue was being caused by the Export/Import plugins by Skyverge which despite speaking to the support for about three weeks I could not get to work.
I’m glad a solution was found, and thank you for updating us on this! I’ll go ahead with marking this thread as resolved now; feel free to open a new one, should you have any further inquiries. Cheers!
- The topic ‘WooCommerce Orders Imports get stuck and WooCommerce Error Message’ is closed to new replies.