High Performance compatibility mode sync no progress?
-
Hi,
i activated the high performance compatibility mode to sync the orders. There are about 13.000 orders to sync – of course this takes some time, but the sync is running for 2 days now and there seems to be no progress. It still shows the same number of pending orders. I see in status > scedules actions that the sync is running continuously again and again, as it should. (wc_run_batch_process) But why is there no progess in the pending numbers?
The page I need help with: [log in to see the link]
-
Hi there @missmikado,
Thanks for reaching out.
But why is there no progess in the pending numbers?
I understand your concern about the sync taking too long without any actual products getting synced.
Your database size, server speed, and other internal factors like plugins can cause the synchronization to take a bit longer to complete.
Furthermore,?could you please disable all plugins except WooCommerce and try syncing the products again?
Let us know how it goes!Hi!
You talk about syncing products – that’s not what I’m doing. I try to sync the orders.
So I had a look at the protocols of the “posts-to-orders-migration” and found out that there are errors when processing order-ids. Seems like none of the orders are synced at all, because the errors startet immediately after starting the process.
2024-03-11T23:30:32+00:00 Fehler order: when processing ids 592, 1147, 1157, 1411, 1446, 1530, 1609…, 10525, 10574: insert operation didn’t complete, the database query failed
In german it is shown as “WordPress-Datenbankfehler: Die Abfrage konnte nicht ausgeführt werden, weil sie ungültige Daten enth?lt.” That’s something like: “Database error: query failed because of invalid data.“
So – is this a problem with a plugin, too? Or what can I do to solve this problem?
Hey, @missmikado!
Thank you for the extra information.
Plugins can still be the cause, as some do not support HPOS and might cause issues. But let’s leave the conflict test on hold for a moment and take a better look at your website information so we can move forward.
To do that, we need to check your System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Also, are all your plugins and the theme updated?
Can you also please try to deactivate HPOS and activating it again to try to reboot the sync to see if it works?
Looking forward to your reply.
Have a wonderful day!
Hi!
Thanks for coming back to me.
All Themes and Plugins are up to date. There is no plugin shown having a conflict with HPOS.
I reactivated the synchronisation, but the same errors appear. I stopped it again to save server ressources.
This is the system report:
` WordPress Environment</p> <p class=””>WordPress address (URL): https://minispatz.de<br>Site address (URL): https://minispatz.de<br>WC Version: 8.6.1<br>REST API Version: ? 8.6.1<br>WC Blocks Version: ? 11.8.0-dev<br>Action Scheduler Version: ? 3.7.2<br>Log Directory Writable: ?<br>WP Version: 6.4.3<br>WP Multisite: –<br>WP Memory Limit: 2 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: de_DE<br>External object cache: ? Server Environment</p> <p class=””>Server Info: LiteSpeed<br>PHP Version: 8.2.16<br>PHP Post Max Size: 64 MB<br>PHP Time Limit: 600<br>PHP Max Input Vars: 2000<br>cURL Version: 7.87.0<br>OpenSSL/1.1.1w</p> <p class=””>SUHOSIN Installed: –<br>MySQL Version: 10.6.16-MariaDB-cll-lve-log<br>Max Upload Size: 64 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database</p> <p class=””>WC Database Version: 8.6.1<br>WC Database Prefix: wpgo_<br>Datenbank-Gesamtgr??e: 1638.53MB<br>Datenbank-Datengr??e: 1289.38MB<br>Datenbank-Indexgr??e: 349.15MB<br>wpgo_woocommerce_sessions: Daten: 2.40MB + Index: 0.02MB + Engine MyISAM<br>wpgo_woocommerce_api_keys: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_order_items: Daten: 2.27MB + Index: 1.43MB + Engine MyISAM<br>wpgo_woocommerce_order_itemmeta: Daten: 124.69MB + Index: 17.03MB + Engine MyISAM<br>wpgo_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_actionscheduler_actions: Daten: 282.65MB + Index: 114.64MB + Engine MyISAM<br>wpgo_actionscheduler_claims: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_actionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_actionscheduler_logs: Daten: 180.38MB + Index: 137.66MB + Engine MyISAM<br>wpgo_addonlibrary_addons: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_addonlibrary_categories: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_asenha_failed_logins: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wpgo_cli_cookie_scan: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cli_cookie_scan_categories: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cli_cookie_scan_cookies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cli_cookie_scan_url: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cli_scripts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cmplz_cookiebanners: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cmplz_cookies: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cmplz_dnsmpd: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_cmplz_services: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_commentmeta: Daten: 0.13MB + Index: 0.12MB + Engine MyISAM<br>wpgo_comments: Daten: 7.44MB + Index: 3.08MB + Engine MyISAM<br>wpgo_cpb_prefilled_products_data: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_dgwt_wcas_stats: Daten: 0.16MB + Index: 0.00MB + Engine InnoDB<br>wpgo_ee_ai_reportdata: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_ee_pmax_campaign: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ee_products_sync_list: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ee_product_feed: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ee_product_sync_call: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ee_product_sync_data: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ee_product_sync_profile: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ee_prouct_pre_sync_data: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wpgo_ee_tiktok_catalog: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_e_events: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_frmt_form_entry: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_frmt_form_entry_meta: Daten: 0.01MB + Index: 0.02MB + Engine MyISAM<br>wpgo_frmt_form_reports: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_frmt_form_views: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_giftvouchers_activity: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_giftvouchers_list: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_giftvouchers_setting: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_giftvouchers_template: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_gla_attribute_mapping_rules: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_gla_budget_recommendations: Daten: 0.10MB + Index: 0.12MB + Engine MyISAM<br>wpgo_gla_merchant_issues: Daten: 0.39MB + Index: 0.02MB + Engine MyISAM<br>wpgo_gla_shipping_rates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_gla_shipping_times: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_gm_invoice_pdf_order_meta: Daten: 154.09MB + Index: 0.12MB + Engine MyISAM<br>wpgo_gm_woocommerce_shipping_order_meta: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpgo_itbbc_history: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpgo_itbbc_history_items: Daten: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpgo_jetpack_sync_queue: Daten: 129.77MB + Index: 14.72MB + Engine MyISAM<br>wpgo_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_litespeed_img_optm: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_litespeed_optimizer: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_automations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_automation_runs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_automation_run_logs: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_automation_run_subjects: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_automation_triggers: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_automation_versions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_custom_fields: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_dynamic_segment_filters: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_feature_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_forms: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_log: Daten: 0.07MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_migrations: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_newsletters: Daten: 0.12MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_newsletter_links: Daten: 0.15MB + Index: 0.07MB + Engine MyISAM<br>wpgo_mailpoet_newsletter_option: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_newsletter_option_fields: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_newsletter_posts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_newsletter_segment: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_newsletter_templates: Daten: 2.70MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_scheduled_tasks: Daten: 0.62MB + Index: 0.17MB + Engine MyISAM<br>wpgo_mailpoet_scheduled_task_subscribers: Daten: 9.28MB + Index: 6.36MB + Engine MyISAM<br>wpgo_mailpoet_segments: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_sending_queues: Daten: 4.84MB + Index: 0.02MB + Engine MyISAM<br>wpgo_mailpoet_settings: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_statistics_bounces: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_statistics_clicks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_statistics_forms: Daten: 0.01MB + Index: 0.02MB + Engine MyISAM<br>wpgo_mailpoet_statistics_newsletters: Daten: 0.01MB + Index: 0.02MB + Engine MyISAM<br>wpgo_mailpoet_statistics_opens: Daten: 0.01MB + Index: 0.04MB + Engine MyISAM<br>wpgo_mailpoet_statistics_unsubscribes: Daten: 0.03MB + Index: 0.03MB + Engine MyISAM<br>wpgo_mailpoet_statistics_woocommerce_purchases: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_stats_notifications: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_subscribers: Daten: 1.18MB + Index: 2.00MB + Engine MyISAM<br>wpgo_mailpoet_subscriber_custom_field: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_subscriber_ips: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_subscriber_segment: Daten: 0.47MB + Index: 0.38MB + Engine MyISAM<br>wpgo_mailpoet_subscriber_tag: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_tags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mailpoet_user_agents: Daten: 0.03MB + Index: 0.01MB + Engine MyISAM<br>wpgo_mailpoet_user_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_mail_catcher_logs: Daten: 19.14MB + Index: 0.01MB + Engine MyISAM<br>wpgo_masterslider_options: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_masterslider_sliders: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_actions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_action_meta: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_chunks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_fields: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_field_meta: Daten: 0.04MB + Index: 0.01MB + Engine MyISAM<br>wpgo_nf3_forms: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_form_meta: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_objects: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_object_meta: Daten: 0.16MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_relationships: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nf3_upgrades: Daten: 0.03MB + Index: 0.00MB + Engine MyISAM<br>wpgo_nm_personalized: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_options: Daten: 31.60MB + Index: 3.04MB + Engine MyISAM<br>wpgo_pimwick_gift_card: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wpgo_pimwick_gift_card_activity: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wpgo_pmxe_exports: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_pmxe_google_cats: Daten: 0.26MB + Index: 0.05MB + Engine MyISAM<br>wpgo_pmxe_posts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_pmxe_templates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_postmeta: Daten: 236.84MB + Index: 29.40MB + Engine MyISAM<br>wpgo_posts: Daten: 36.69MB + Index: 2.00MB + Engine MyISAM<br>wpgo_rank_math_internal_links: Daten: 0.07MB + Index: 0.02MB + Engine MyISAM<br>wpgo_rank_math_internal_meta: Daten: 0.01MB + Index: 0.01MB + Engine MyISAM<br>wpgo_sm_tasks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_sm_task_details: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_termmeta: Daten: 0.03MB + Index: 0.03MB + Engine MyISAM<br>wpgo_terms: Daten: 0.03MB + Index: 0.06MB + Engine MyISAM<br>wpgo_term_relationships: Daten: 0.10MB + Index: 0.22MB + Engine MyISAM<br>wpgo_term_taxonomy: Daten: 0.02MB + Index: 0.02MB + Engine MyISAM<br>wpgo_tm_taskmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_tm_tasks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_trustindex_google_reviews: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ulike: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ulike_activities: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ulike_comments: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_ulike_forums: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_usermeta: Daten: 9.66MB + Index: 4.85MB + Engine MyISAM<br>wpgo_users: Daten: 0.54MB + Index: 0.45MB + Engine MyISAM<br>wpgo_wa_confirmationlinks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wa_log: Daten: 0.50MB + Index: 0.04MB + Engine MyISAM<br>wpgo_wa_queue: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wcdpi_country: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_page_format: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_product_additional: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_product_basic: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_product_sales: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_shipment: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_shipment_attachment: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_shipment_item: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_t_app_service: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_t_app_service_feature: Daten: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wcdpi_t_app_service_provider: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wc_admin_notes: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_admin_note_actions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_category_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_customer_lookup: Daten: 0.73MB + Index: 0.67MB + Engine MyISAM<br>wpgo_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_orders: Daten: 0.18MB + Index: 0.13MB + Engine MyISAM<br>wpgo_wc_orders_meta: Daten: 0.79MB + Index: 1.15MB + Engine MyISAM<br>wpgo_wc_order_addresses: Daten: 0.12MB + Index: 0.10MB + Engine MyISAM<br>wpgo_wc_order_coupon_lookup: Daten: 0.04MB + Index: 0.07MB + Engine MyISAM<br>wpgo_wc_order_operational_data: Daten: 0.09MB + Index: 0.04MB + Engine MyISAM<br>wpgo_wc_order_product_lookup: Daten: 1.93MB + Index: 1.70MB + Engine MyISAM<br>wpgo_wc_order_stats: Daten: 1.18MB + Index: 0.64MB + Engine MyISAM<br>wpgo_wc_order_tax_lookup: Daten: 0.53MB + Index: 0.58MB + Engine MyISAM<br>wpgo_wc_product_attributes_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_product_download_directories: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_wc_product_meta_lookup: Daten: 0.03MB + Index: 0.05MB + Engine MyISAM<br>wpgo_wc_rate_limits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wdr_order_discounts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wdr_order_item_discounts: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wdr_rules: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfblockediplog: Daten: 0.17MB + Index: 0.11MB + Engine MyISAM<br>wpgo_wfblocks7: Daten: 0.12MB + Index: 0.04MB + Engine MyISAM<br>wpgo_wfconfig: Daten: 5.59MB + Index: 0.02MB + Engine MyISAM<br>wpgo_wfcrawlers: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wffilechanges: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wffilemods: Daten: 18.29MB + Index: 2.25MB + Engine MyISAM<br>wpgo_wfhits: Daten: 1.02MB + Index: 0.19MB + Engine MyISAM<br>wpgo_wfhoover: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfissues: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wpgo_wfknownfilelist: Daten: 13.03MB + Index: 0.69MB + Engine MyISAM<br>wpgo_wflivetraffichuman: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wflocs: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wpgo_wflogins: Daten: 0.94MB + Index: 0.18MB + Engine MyISAM<br>wpgo_wfls_2fa_secrets: Daten: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpgo_wfls_role_counts: Daten: 0.00MB + Index: 0.00MB + Engine MEMORY<br>wpgo_wfls_settings: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpgo_wfnotifications: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfpendingissues: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfpklist_template_data: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfreversecache: Daten: 0.02MB + Index: 0.01MB + Engine MyISAM<br>wpgo_wfsecurityevents: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfsnipcache: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfstatus: Daten: 0.62MB + Index: 0.26MB + Engine MyISAM<br>wpgo_wftrafficrates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wfwaffailures: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_woocommerce_shipping_table_rate: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wt_iew_action_history: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM<br>wpgo_wt_iew_mapping_template: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wpgo_yith_wcwl: Daten: 0.58MB + Index: 0.30MB + Engine MyISAM<br>wpgo_yith_wcwl_lists: Daten: 0.69MB + Index: 0.41MB + Engine MyISAM<br>wpgo_yoast_indexable: Daten: 0.28MB + Index: 0.08MB + Engine MyISAM<br>wpgo_yoast_indexable_hierarchy: Daten: 0.07MB + Index: 0.21MB + Engine MyISAM<br>wpgo_yoast_migrations: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM<br>wpgo_yoast_primary_term: Daten: 0.01MB + Index: 0.02MB + Engine MyISAM<br>wpgo_yoast_seo_links: Daten: 1.76MB + Index: 0.38MB + Engine MyISAM<br>wpgo_yoast_seo_meta: Daten: 0.22MB + Index: 0.27MB + Engine MyISAM Post Type Counts</p> <p class=””>ae_global_templates: 1<br>attachment: 1803<br>automation-retrigger: 1<br>automation-workflow: 1<br>bsf_custom_fonts: 3<br>custom_css: 4<br>elementor_library: 7<br>elementskit_content: 5<br>elementskit_template: 1<br>forminator_forms: 2<br>fpf_fields: 1<br>gift_card: 1<br>is_search_form: 2<br>mailpoet_page: 1<br>nav_menu_item: 67<br>nf_sub: 247<br>oceanwp_library: 2<br>oembed_cache: 4<br>ofb: 1<br>page: 36<br>popup: 1<br>popup_theme: 3<br>post: 2<br>postman_sent_mail: 2<br>product: 329<br>product_variation: 14<br>product-feed: 1<br>shop_coupon: 93<br>shop_order: 2862<br>shop_order_refund: 35<br>tt_font_control: 1<br>uni_cpo_option: 1<br>vpc-config: 1<br>vpc-text-component: 5<br>wc_dynamic_pricing: 1<br>wcpa_pt_forms: 149<br>wcs_ruleset: 1<br>wcssc-cart: 340<br>wp_navigation: 1<br>wp_template: 2<br>wpgv_voucher_product: 1 Security</p> <p class=””>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (46)</p> <p class=””>Add-on WooCommerce MailPoet 3: von Tikweb – 1.1.9<br>Admin and Site Enhancements (ASE): von wpase.com – 6.9.3<br>FiboSearch – AJAX Search for WooCommerce: von FiboSearch Team – 1.27.0<br>Async JavaScript: von Frank Goossens (futtta) – 2.21.08.31<br>Product Feed Manager for WooCommerce: von RexTheme – 7.3.28<br>Complianz | GDPR/CCPA Cookie Consent: von Really Simple Plugins – 7.0.4<br>Custom Fonts: von Brainstorm Force – 2.1.3<br>Decorator – WooCommerce Email Customizer: von WebToffee – 1.2.9<br>DHL Shipping Germany for WooCommerce: von DHL – 3.6.4<br>Elementor: von Elementor.com – 3.20.1<br>Error Log Monitor: von Janis Elsts – 1.7.7<br>Essential Addons for Elementor: von WPDeveloper – 5.9.11<br>Facebook for WooCommerce: von Facebook – 3.1.11<br>Forminator: von WPMU DEV – 1.29.2<br>Google Listings and Ads: von WooCommerce – 2.6.2<br>Icon Element: von Webangon – 2.0.5<br>Jetpack: von Automattic – 13.2.1<br>Table Rate Shipping: von Kahanit – 1.2.1<br>Klarna Order Management for WooCommerce: von klarna<br>krokedil – 1.9.1</p> <p class=””>Klarna Payments for WooCommerce: von klarna – 3.4.1<br>Local Google Fonts: von EverPress – 0.22.0<br>Loco Translate: von Tim Whitlock – 2.6.6<br>MailPoet: von MailPoet – 4.46.0<br>Members: von MemberPress – 3.2.9<br>Ninja Forms: von Saturday Drive – 3.8.0<br>Ocean Extra: von OceanWP – 2.2.6<br>Order Status Rules for WooCommerce: von WPFactory – 3.5.1<br>PW WooCommerce Gift Cards Pro: von Pimwick<br>LLC – 1.473</p> <p class=””>Zahlungs-Plugins für PayPal WooCommerce: von Zahlungs-Plugins<br>[email protected] – 1.0.45</p> <p class=””>Qi Addons For Elementor: von Qode Interactive – 1.6.9<br>Royal Elementor Addons: von WP Royal – 1.3.93<br>Rank Math SEO: von Rank Math – 1.0.214<br>Tidio Chat: von Tidio LLC – 6.0.16<br>W3 Total Cache: von BoldGrid – 2.7.0<br>Woocommerce Custom Product Addons (5.x.x): von Acowebs – 5.1.0<br>Category Discount Woocommerce: von QuanticEdge – 4.14<br>Save and Share Cart for WooCommerce: von Ankit Gade – 2.0.5<br>WooCommerce Extended Coupon Features FREE: von Soft79 – 3.3.3<br>German Market: von MarketPress – 3.35.1<br>Google Analytics for WooCommerce: von WooCommerce – 2.0.3<br>WooCommerce: von Automattic – 8.6.1<br>Mail logging – WP Mail Catcher: von James Ward – 2.1.7<br>Widgets for Google Reviews: von Trustindex.io – 11.7<br>Social Chat: von QuadLayers – 7.3.4<br>Sequential Order Numbers for WooCommerce: von WebToffee – 1.6.0<br>YITH WooCommerce Wunschliste: von YITH – 3.31.0 Inactive Plugins (2)</p> <p class=””>Conversios.io – All-in-one Google Analytics, Pixels and Product Feed Manager for WooCommerce: von Conversios – 7.0.5<br>Import Export WordPress Users and WooCommerce Customers: von WebToffee – 2.5.3 Dropin Plugins (4)</p> <p class=””>advanced-cache.php: advanced-cache.php<br>db.php: db.php<br>maintenance.php: maintenance.php<br>object-cache.php: object-cache.php Must Use Plugins (1)</p> <p class=””>Elementor Safe Mode: von Elementor.com – 1.0.0 Settings</p> <p class=””>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>pw gift card (pw-gift-card)<br>simple (simple)<br>variable (variable)<br>wdm_bundle_product (wdm_bundle_product)<br>woosb (woosb)</p> <p class=””>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)</p> <p class=””>Connected to Woo.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</p> <p class=””>Shop-Basis: #6 – /shop/<br>Warenkorb: #7 – /warenkorb/<br>Kasse: #8 – /kasse/<br>Mein Konto: #9 – /mein-konto/<br>Allgemeine Gesch?ftsbedingungen: #265 – /agb/ Theme</p> <p class=””>Name: OceanWP Child Theme<br>Version: 1.0<br>Author URL: https://oceanwp.org/<br>Child Theme: ?<br>Parent Theme Name: OceanWP<br>Parent Theme Version: 3.5.4<br>Parent Theme Author URL: https://oceanwp.org/about-oceanwp/<br>WooCommerce Support: ? Templates</p> <p class=””>Overrides: /home/minispat/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/cart/cart.php<br>/home/minispat/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/cart/mini-cart.php<br>oceanwp/woocommerce/content-single-product.php<br>oceanwp/woocommerce/loop/loop-start.php<br>/home/minispat/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/error.php Version 3.9.0 ist veraltet. Die Hauptversion ist 8.6.0<br>/home/minispat/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/notice.php Version 3.9.0 ist veraltet. Die Hauptversion ist 8.6.0<br>/home/minispat/public_html/wp-content/plugins/royal-elementor-addons/includes/woocommerce/templates/notices/success.php Version 3.9.0 ist veraltet. Die Hauptversion ist 8.6.0<br>oceanwp/woocommerce/single-product/product-image.php<br>oceanwp/woocommerce/single-product/title.php</p> <p class=””>Outdated Templates: ?</p> <pre class=”wp-block-code”><code> Erfahre</code></pre> <p class=””>wie du aktualisieren kannst Pimwick Plugins</p> <p class=””>PW WooCommerce Gift Cards Pro: License key: PW-61abdeb74af74<br>Result: success<br>Cached: 2024-03-15 Klarna Payments Request Log</p> <p class=””>2023-02-24 10:48:04: KP Create Session<br>Response code: 401<br>Response message: {“headers”:[],”body”:”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}}<br /> Correlation ID:</p> <p>2023-02-24 10:48:04: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-24 10:48:04: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-23 13:43:55: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-23 13:43:55: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-20 22:38:09: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-20 22:37:18: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 16:04:21: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 16:00:31: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 16:00:17: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 16:00:12: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 16:00:11: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 16:00:11: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 15:59:46: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <p>2023-02-17 15:59:44: KP Create Session<br /> Response code: 401<br /> 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}}<br /> Correlation ID:</p> <h3>Klarna Countries</h3> <p>Production Countries: DE<br /> Test Countries: No countries selected</p> <h3>Admin</h3> <p>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 /> product-virtual-downloadable<br /> product-external-affiliate<br /> product-grouped<br /> product-linked<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</p> <p>Disabled Features: customize-store<br /> minified-js<br /> new-product-management-experience<br /> product-pre-publish-modal<br /> settings<br /> async-product-editor-category-field</p> <p>Daily Cron: ? Next scheduled: 2024-03-15 18:48:39 +00:00<br /> Options: ?<br /> Notes: 22<br /> Onboarding: completed</p> <h3>MailPoet</h3> <p>Sending Method: MailPoet<br /> Send all site’s emails with: Aktuelle Versandmethode<br /> Task Scheduler method: Action Scheduler<br /> Cron ping URL: https://minispatz.de?mailpoet_router&endpoint=cron_daemon&action=ping</p> <h3>Action Scheduler</h3> <p>Complete: 379<br /> Oldest: 2024-03-15 07:58:07 +0000<br /> Newest: 2024-03-15 15:42:58 +0000</p> <p>Failed: 2<br /> Oldest: –<br /> Newest: –</p> <p>Pending: 18<br /> Oldest: 2024-03-15 15:43:19 +0000<br /> Newest: 2024-03-22 07:31:28 +0000</p> <h3>Status report information</h3> <p>Generated at: 2024-03-15 15:43:58 +00:00<br /> `</p>
Hi @missmikado,
Thank you for the additional details.
All Themes and Plugins are up to date. There is no plugin shown having a conflict with HPOS.
Can you confirm you’ve executed a conflict test, though? It may not be apparent, but I see you have 46 active plugins on your site right now and one of them may be causing issues without realizing it.
To test, you’ll first want to change the theme on your site to Storefront, then check to see if the issue is still present. If that resolves the issue, you’ll want to get in touch with your theme’s developer and see if they have an update or fix for you.
If changing the theme doesn’t help, you’ll want to deactivate all plugins except for WooCommerce and take a look. If that fixes the problem, re-enable the other plugins one by one (gradually), checking after each to see where the issue is coming from.Some important considerations:?
— Be sure you have a good backup in place of your full site and database. You can ask your host for backup functionality, or you can consider using a service like?Jetpack. If something goes wrong, you will be able to restore it.
— Also, you can consider using a plugin like?Health Check & Troubleshooting. This is a plugin developed by the WordPress community, and it is helpful to disable plugins without affecting your current site visitors.
— It is also important to consider staging functionality in case you would not like to touch your production site (you can ask your host if they offer this service), or you can use WP Staging to spin up a new test site quickly.
You can find more about this in this?guide.
Please let us know about your findings.
-OPHi,
I switched to storefront and ran the synchronisation again. Same error.
I disabled all other plugins than Woocommerce and ran the synchronisation again. Same error.
So, what’s next…?
Hi @missmikado,
Seems like we’ll need to have a closer look. Could you please open a ticket about this from Woo.com > My profile > Support?
Make sure to include a link to this thread, so we know what has been done already.
Thanks!
- The topic ‘High Performance compatibility mode sync no progress?’ is closed to new replies.