HPOS Sync Error
-
I had enabled HPOS yet synced with the postmeta mode.
Realised that after a couple of days 11 (out of about 200) did not sync. Tried to do this manually and this is what I got:This feature is not production ready yet. Make sure you are not running these co mmands in your production environment.
Υπ?ρχουν 11 παραγγελ?ε? προ? συγχρονισμ?.
WordPress database error Duplicate entry '' for key 'order_key' for query INSERT INTO wp_wc_order_operational_data (order_id
,created_via
,woocommerce_vers ion
,prices_include_tax
,coupon_usages_are_counted
,download_permission_gr anted
,cart_hash
,new_order_email_sent
,order_key
,order_stock_reduced
,date_paid_gmt
,date_completed_gmt
,shipping_tax_amount
,shipping_total_a mount
,discount_tax_amount
,discount_total_amount
,recorded_sales
) VALUES ('105765', '', '7.7.0', '0', '0', '0', '', '0', '', '0', '', '', '0.000000', '0 .000000', '0.000000', '0.000000', '0'),('105766', '', '7.7.0', '0', '0', '0', '' , '0', '', '0', '', '', '0.000000', '0.000000', '0.000000', '0.000000', '0'),('1 05930', '', '7.7.0', '0', '0', '0', '', '0', '', '0', '', '', '0.000000', '0.000 000', '0.000000', '0.000000', '0'); made by include('phar:///usr/local/bin/wp/ph p/boot-phar.php'), include('phar:///usr/local/bin/wp/vendor/wp-cli/wp-cli/php/wp -cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Run ner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_ CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFact ory::WP_CLI\Dispatcher{closure}, call_user_func, Automattic\WooCommerce\DataBas e\Migrations\CustomOrderTable\CLIRunner->sync, Automattic\WooCommerce\Internal\D ataStores\Orders\DataSynchronizer->process_batch, Automattic\WooCommerce\Databas e\Migrations\CustomOrderTable\PostsToOrdersMigrationController->migrate_orders, Automattic\WooCommerce\Database\Migrations\CustomOrderTable\PostsToOrdersMigrati onController->do_orders_migration_step, Automattic\WooCommerce\Database\Migratio ns\TableMigrator->process_migration_batch_for_ids, Automattic\WooCommerce\Databa se\Migrations\MetaToCustomTableMigrator->process_migration_batch_for_ids_core, A utomattic\WooCommerce\Database\Migrations\MetaToCustomTableMigrator->process_ins ert_batch, Automattic\WooCommerce\Database\Migrations\TableMigrator->db_query
Order Data Sync 100% [============================================] 0:00 / 0:00—-
The trouble is that I cannot even find order 105765
Please advise.
-
Hi @dimitrisv
Would you mind including a System Status Report as well? That might help us track down where the issue is here.
Thanks,
Jon
Here it is:
WordPress Environment WordPress address (URL): https://femme-fatale.gr Site address (URL): https://femme-fatale.gr WC Version: 7.7.0 REST API Version: ? 7.7.0 WC Blocks Version: ? 10.2.0 Action Scheduler Version: ? 3.5.4 Log Directory Writable: ? WP Version: 6.2 WP Multisite: – WP Memory Limit: 8 GB WP Debug Mode: – WP Cron: ? Language: el External object cache: ? Server Environment Server Info: Apache/2.4.54 (Debian) PHP Version: 8.0.28 PHP Post Max Size: 512 MB PHP Time Limit: 3600 PHP Max Input Vars: 20000 cURL Version: 7.64.0 OpenSSL/1.1.1d SUHOSIN Installed: – MySQL Version: 10.6.3-MariaDB-1:10.6.3+maria~buster-log Max Upload Size: 500 MB Default Timezone is UTC: ? fsockopen/cURL: ? SoapClient: ? DOMDocument: ? GZip: ? Multibyte String: ? Remote Post: ? Remote Get: ? Database WC Database Version: 7.7.0 WC Database Prefix: wp_ Total Database Size: 3331.35MB Database Data Size: 1749.59MB Database Index Size: 1581.76MB wp_woocommerce_sessions: Data: 233.30MB + Index: 3.03MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 12.52MB + Index: 3.52MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 64.59MB + Index: 50.14MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.08MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_acsell_product_data: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_actionscheduler_actions: Data: 13.16MB + Index: 17.17MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 16.23MB + Index: 8.09MB + Engine InnoDB wp_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_admin_columns: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_aioseo_cache: Data: 12.13MB + Index: 9.06MB + Engine InnoDB wp_aioseo_links: Data: 25.55MB + Index: 0.86MB + Engine InnoDB wp_aioseo_links_suggestions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_aioseo_notifications: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_aioseo_posts: Data: 30.56MB + Index: 0.50MB + Engine InnoDB wp_aioseo_redirects: Data: 7.52MB + Index: 7.25MB + Engine InnoDB wp_aioseo_redirects_404: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_aioseo_redirects_404_logs: Data: 11.02MB + Index: 1.86MB + Engine InnoDB wp_aioseo_redirects_hits: Data: 0.52MB + Index: 0.67MB + Engine InnoDB wp_aioseo_redirects_logs: Data: 14.02MB + Index: 2.98MB + Engine InnoDB wp_aioseo_search_statistics_objects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_aioseo_terms: Data: 1.52MB + Index: 0.13MB + Engine InnoDB wp_alphabank_transactions: Data: 0.09MB + Index: 0.00MB + Engine InnoDB wp_automatewoo_abandoned_carts: Data: 1.42MB + Index: 0.08MB + Engine InnoDB wp_automatewoo_customers: Data: 2.52MB + Index: 5.91MB + Engine InnoDB wp_automatewoo_customer_meta: Data: 1.52MB + Index: 1.81MB + Engine InnoDB wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatewoo_guests: Data: 1.52MB + Index: 2.52MB + Engine InnoDB wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatewoo_logs: Data: 1.52MB + Index: 2.41MB + Engine InnoDB wp_automatewoo_log_meta: Data: 7.52MB + Index: 5.03MB + Engine InnoDB wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatewoo_queue_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_automatewoo_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_automatewoo_referral_advocate_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_automatewoo_referral_invites: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_bv_fw_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_bv_ip_store: Data: 0.38MB + Index: 0.20MB + Engine InnoDB wp_bv_lp_requests: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cardlink_gateway_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cli_cookie_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cli_cookie_scan_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cli_cookie_scan_cookies: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_cli_cookie_scan_url: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cli_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_comments: Data: 21.55MB + Index: 19.61MB + Engine InnoDB wp_cs_proof_consent: Data: 5.52MB + Index: 0.00MB + Engine InnoDB wp_cs_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cs_scan_cookies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cs_scan_scripts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cs_stats_consent: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_cs_unblock_ip: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_events: Data: 29.55MB + Index: 0.00MB + Engine InnoDB wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_draft_submissions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_gf_entry: Data: 0.33MB + Index: 0.08MB + Engine InnoDB wp_gf_entry_meta: Data: 1.52MB + Index: 2.31MB + Engine InnoDB wp_gf_entry_notes: Data: 0.23MB + Index: 0.06MB + Engine InnoDB wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gf_form_meta: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_gf_form_revisions: Data: 1.50MB + Index: 0.03MB + Engine InnoDB wp_gf_form_view: Data: 0.13MB + Index: 0.13MB + Engine InnoDB wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_masterslider_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_masterslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mo_openid_linked_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastecon_activities: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_namastecon_comments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastecon_maillog: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_namastecon_newsletters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_badges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_bundles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_classes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_class_managers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_coupons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_delayed_access: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_school_signups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_school_students: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_shopcarts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namastepro_student_classes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_certificates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_course_reviews: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_history: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_namaste_homeworks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_homework_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_solution_files: Data: 1.50MB + Index: 0.00MB + Engine InnoDB wp_namaste_student_certificates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_namaste_student_courses: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_namaste_student_homeworks: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_namaste_student_lessons: Data: 0.14MB + Index: 0.00MB + Engine InnoDB wp_namaste_student_modules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_namaste_visits: Data: 0.17MB + Index: 0.00MB + Engine InnoDB wp_namaste_webhooks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 7.52MB + Index: 0.41MB + Engine InnoDB wp_pmxe_exports: Data: 1.47MB + Index: 0.00MB + Engine InnoDB wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB wp_pmxe_posts: Data: 6.52MB + Index: 0.00MB + Engine InnoDB wp_pmxe_templates: Data: 1.48MB + Index: 0.00MB + Engine InnoDB wp_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_hash: Data: 4.52MB + Index: 0.00MB + Engine InnoDB wp_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pmxi_images: Data: 3.52MB + Index: 0.00MB + Engine InnoDB wp_pmxi_imports: Data: 2.50MB + Index: 0.00MB + Engine InnoDB wp_pmxi_posts: Data: 14.52MB + Index: 0.00MB + Engine InnoDB wp_pmxi_templates: Data: 1.50MB + Index: 0.00MB + Engine InnoDB wp_podsrel: Data: 0.05MB + Index: 0.06MB + Engine InnoDB wp_pods_cssurvey: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_pods_cssurveypd: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pods_order_products_analytics: Data: 12.55MB + Index: 3.52MB + Engine InnoDB wp_pods_order_stats: Data: 12.55MB + Index: 1.52MB + Engine InnoDB wp_pods_pa_brand_master: Data: 0.03MB + Index: 0.00MB + Engine InnoDB wp_pods_post: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pods_product_brands: Data: 1.52MB + Index: 1.52MB + Engine InnoDB wp_pods_product_cat: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pods_product_vitals: Data: 15.55MB + Index: 0.30MB + Engine InnoDB wp_pods_reciprocal_product: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_postmeta: Data: 291.89MB + Index: 377.59MB + Engine InnoDB wp_posts: Data: 83.53MB + Index: 19.06MB + Engine InnoDB wp_po_plugins: Data: 24.53MB + Index: 8.89MB + Engine InnoDB wp_pys_stat_landing: Data: 0.34MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_order: Data: 0.34MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_product_order: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_utm_campaing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_utm_content: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pys_stat_utm_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_sbi_feed_caches: Data: 0.16MB + Index: 0.02MB + Engine InnoDB wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_sbi_instagram_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_searchwp_index: Data: 468.00MB + Index: 731.33MB + Engine InnoDB wp_searchwp_log: Data: 5.02MB + Index: 8.58MB + Engine InnoDB wp_searchwp_status: Data: 1.05MB + Index: 0.92MB + Engine InnoDB wp_searchwp_tokens: Data: 8.52MB + Index: 15.55MB + Engine InnoDB wp_sgs_log_events: Data: 0.23MB + Index: 0.13MB + Engine InnoDB wp_sgs_log_visitors: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_swpext_metrics_clicks: Data: 1.52MB + Index: 0.78MB + Engine InnoDB wp_swpext_metrics_ids: Data: 18.55MB + Index: 28.13MB + Engine InnoDB wp_swpext_metrics_meta: Data: 32.56MB + Index: 23.58MB + Engine InnoDB wp_swpext_metrics_queries: Data: 1.52MB + Index: 2.52MB + Engine InnoDB wp_swpext_metrics_searches: Data: 13.52MB + Index: 28.58MB + Engine InnoDB wp_termmeta: Data: 2.50MB + Index: 4.52MB + Engine InnoDB wp_terms: Data: 0.45MB + Index: 0.64MB + Engine InnoDB wp_term_relationships: Data: 6.48MB + Index: 4.52MB + Engine InnoDB wp_term_taxonomy: Data: 1.52MB + Index: 0.56MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_usermeta: Data: 23.58MB + Index: 44.73MB + Engine InnoDB wp_users: Data: 1.52MB + Index: 1.78MB + Engine InnoDB wp_vivawallet_data: Data: 0.11MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 3.52MB + Index: 2.95MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_orders: Data: 8.52MB + Index: 13.55MB + Engine InnoDB wp_wc_orders_meta: Data: 37.56MB + Index: 55.44MB + Engine InnoDB wp_wc_order_addresses: Data: 8.52MB + Index: 11.06MB + Engine InnoDB wp_wc_order_composite_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_operational_data: Data: 5.52MB + Index: 4.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 9.52MB + Index: 10.03MB + Engine InnoDB wp_wc_order_stats: Data: 4.52MB + Index: 4.53MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_product_attributes_lookup: Data: 3.52MB + Index: 3.48MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 2.52MB + Index: 5.03MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wiz_cummulative_order_stats: Data: 10.52MB + Index: 1.52MB + Engine InnoDB wp_wiz_order_products_entry: Data: 3.52MB + Index: 1.52MB + Engine InnoDB wp_wiz_order_products_exit: Data: 3.52MB + Index: 1.52MB + Engine InnoDB wp_wiz_order_products_freq_entry: Data: 2.52MB + Index: 0.09MB + Engine InnoDB wp_wiz_order_products_freq_exit: Data: 2.52MB + Index: 0.11MB + Engine InnoDB wp_wiz_order_products_freq_single_item_orders: Data: 1.52MB + Index: 0.06MB + Engine InnoDB wp_wiz_order_products_single_orders: Data: 1.52MB + Index: 0.31MB + Engine InnoDB wp_wiz_order_stats: Data: 14.55MB + Index: 1.52MB + Engine InnoDB wp_wiz_product_brands: Data: 1.52MB + Index: 0.30MB + Engine InnoDB wp_woobe_history: Data: 1.52MB + Index: 0.80MB + Engine InnoDB wp_woobe_history_bulk: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_orders: Data: 8.52MB + Index: 2.31MB + Engine InnoDB wp_woocommerce_pickup_locations_geodata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_recommendations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_session_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_table_rates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woot_tables: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_woot_tables_columns: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woot_tables_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woot_vocabulary: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpdatacharts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wpdatatables: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wpdatatables_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpdatatables_columns: Data: 0.19MB + Index: 0.00MB + Engine InnoDB wp_wpdatatables_rows: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpr_rocket_cache: Data: 2.52MB + Index: 3.73MB + Engine InnoDB wp_wpr_rucss_used_css: Data: 0.39MB + Index: 0.72MB + Engine InnoDB Post Type Counts _pods_field: 230 _pods_group: 12 _pods_pod: 12 attachment: 24055 aw_workflow: 12 consentmagic: 3 cookielawinfo: 6 cpt_variation_fields: 1 cs-template: 4 custom_css: 3 customize_changeset: 13 faq: 3 fgf_rules: 1 filter_group: 1 gfw_event: 2 gfw_report: 524 gift_card: 1 mailpoet_page: 1 mgmlp_media_folder: 95 namaste_course: 17 namaste_homework: 4 namaste_lesson: 28 named_filter_type: 33 nav_menu_item: 717 oembed_cache: 1 page: 84 plugin_filter: 5 post: 81 product: 13446 product_variation: 3717 revision: 33 saved_reply: 2 shop_coupon: 73 shop_order: 28759 shop_order_refund: 9 tdb_templates: 24 tds_locker: 1 ticket: 17 wc_pickup_location: 4 wcpf_item: 8 wcpf_project: 1 wishlist: 4 wp_block: 4 wp_global_styles: 2 wpcode: 2 wpforms: 2 yith_wcan_preset: 1 yith_wcps_type: 3 Security Secure connection (HTTPS): ? Hide errors from visitors: ? Active Plugins (96) Plugin Organizer: by Jeff Sterup – 10.1.9 SiteGround Security: by SiteGround – 1.4.5 Loco Translate: by Tim Whitlock – 2.6.4 Members: by MemberPress – 3.2.5 User Role Editor: by Vladimir Garagulya – 4.63.3 Pods - Custom Content Types and Fields: by Pods Framework Team – 2.9.13 weLaunch Framework: by weLaunch.io – 1.0.14 WooCommerce: by Automattic – 7.7.0 WooCommerce Product Manual Sorting Performance Improvement: by Hayden Whiteman – Woocommerce Advanced Categories: by weLaunch – 1.2.20 WooCommerce UPC, EAN, and ISBN: by Scott Bolinger – 0.5.1 WooCommerce Custom Fields for Variations by Iconic: by Iconic – 1.4.0 WooCommerce Ultimate Pricing: by weLaunch – 1.1.4 WooCommerce Blocks: by Automattic – 10.2.0 Category Order and Taxonomy Terms Order: by Nsp-Code – 1.7.5 ReOrder Posts within Categories: by Aurorata V. – 2.14.2 Max Mega Menu: by megamenu.com – 3.2.2 All in One SEO Pro: by All in One SEO Team – 4.3.7 TC Custom JavaScript: by Tiny Code – 1.2.3 Botiga Pro: by aThemes – 1.2.3 aThemes Blocks: by aThemes – 1.0.10 Site Kit by Google: by Google – 1.99.0 Disable Bloat for WordPress & WooCommerce: by Disable Bloat – 3.2.4 Variable Font Sizes for Mobile: by Dimitris Vayenas - Oxford Metadata – 1.1.0 aThemes Starter Sites: by aThemes – 1.0.35 SearchWP Customizations: by – 1.0.2 SearchWP Custom Results Order: by SearchWP – 1.3.6 SearchWP Metrics: by SearchWP – 1.4.3 SearchWP Related: by SearchWP – 1.4.8 SearchWP WooCommerce Integration: by SearchWP – 1.3.11 SearchWP: by SearchWP – 4.3.1 Gravity Forms: by Gravity Forms – 2.7.6 AIOSEO - Image SEO: by All in One SEO Team – 1.1.7 AIOSEO - IndexNow: by All in One SEO Team – 1.0.10 AIOSEO - Local Business: by All in One SEO Team – 1.2.16 AIOSEO - Redirects: by All in One SEO Team – 1.2.11 AutoConvert Greeklish Permalinks: by Dimitris Mavroudis – 4.1.1 AutomateWoo - Birthdays Add-on: by WooCommerce – 1.3.17 AutomateWoo - Refer A Friend Add-on: by WooCommerce – 2.6.19 AutomateWoo: by WooCommerce – 5.7.2 Change Date Language (English speakers): by Marco Foggia – 0.1.1 CIO Custom Fields Importer: by VisualData – 1.0.3 Free Gifts for WooCommerce: by Flintop – 9.5.0 Gravity Forms Color Picker: by JetSloth – 1.1.44 Gravity Forms Survey Add-On: by Gravity Forms – 3.8 Gravity Forms User Registration Add-On: by Gravity Forms – 5.1 GTmetrix for WordPress: by GTmetrix – 0.4.7 Index WP MySQL For Speed: by Oliver Jones Rick James – 1.4.12 Pods Gravity Forms Add-On: by Pods Framework Team – 1.4.5 Preserve Page and Taxonomy Hierarchy on Edit Menus Screen: by Sergey Biryukov – 0.1 Product Catalog Feed Pro by PixelYourSite: by PixelYourSite – 5.3.1 Timologia for WooCommerce: by John Athanasiou – 5.0 Soft1 Orders: by – 1.0 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 2.23.3.26 Visual Term Description Editor: by Shea Bunge – 1.8.1 WooCommerce Payment Gateway Based Fees: by InoPlugs – 3.2.3 WooCommerce PayPal Payments: by WooCommerce – 2.0.4 Viva Wallet Smart Checkout: by Viva Wallet – 3.6.8 Phone Orders and Payments: by 99w – 1.3.0 WooCommerce Table Rate Shipping: by WooCommerce – 3.1.0 WooCommerce Local Pickup Plus: by SkyVerge – 2.9.10 WooCommerce Shipping & Tax: by WooCommerce – 2.2.4 WooCommerce Shipment Tracking: by WooCommerce – 2.0.0 WooCommerce Packing Slips: by weLaunch – 1.2.10 Repeat Order for Woocommerce: by polyres – 1.2.0 PixelYourSite PRO: by PixelYourSite – 9.6.1 PixelYourSite Super Pack: by PixelYourSite – 3.3.0 wpDataTables: by TMS-Plugins – 5.5 Powerful Filters for wpDataTables: by TMS-Plugins – 1.4.2 Master-Detail Tables for wpDataTables: by TMS-Plugins – 1.3.5 BEAR – Bulk Editor and Products Manager Professional for WooCommerce: by realmag777 – 2.1.3.1 WooCommerce Composite Products: by WooCommerce – 8.7.4 Gift Wrapper Plus: by Sagehen Studio – 5.2.11 WooCommerce Shop the Look: by weLaunch – 1.0.8 WooCommerce Social Login: by SkyVerge – 2.12.0 BOX NOW Delivery: by BOX NOW – 1.5 WOOT - WooCommerce Active Products Tables: by realmag777 – 2.0.6 WP All Export Pro: by Soflyy – 1.8.3 WP All Import Pro: by Soflyy – 4.7.9 WP All Export - User Export Add-On Pro: by Soflyy – 1.0.7 WP All Export - WooCommerce Export Add-On Pro: by Soflyy – 1.0.6 WP All Import - WooCommerce Import Add-On Pro: by Soflyy – 3.3.4 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5 Acsell Product Filters: by Acsell – 1.0.5 Namaste! Connect: by Kiboko Labs – 1.0.7 Namaste! LMS: by Kiboko Labs – 2.6.0.1 Namaste! PRO: by Kiboko Labs – 1.5.6 BestPrice 360 Analytics Integration: by BestPrice – 1.1.1 Skroutz Analytics for WooCommerce: by Skroutz – 1.7.1 PDF Bridge: by Kiboko Labs – 1.9 Better Search Replace Pro: by Delicious Brains – 1.4.2 WP Rocket: by WP Media – 3.13.2 WP Rocket | Remove HTML Expires from .htaccess rules: by WP Rocket Support Team – WP Mail SMTP: by WP Mail SMTP – 3.8.0 Temporary Login Without Password: by StoreApps – 1.8.1.1 XML Generator: by Dimitris Vayenas – 1.0 Inactive Plugins (13) ConsentMagic Pro: by ConsentMagic – 2.0.1 CookieYes | GDPR Cookie Consent: by CookieYes – 3.0.9 Envato Market: by Envato – 2.0.8 Gravity Forms Google Analytics Add-On: by Gravity Forms – 1.2 Gravity Forms Polls Add-On: by Gravity Forms – 4.0 Instagram Feed Pro Developer: by Smash Balloon – 6.2.2 Mouseflow for WordPress: by Mouseflow – 5.1.2 Post Types Order: by Nsp Code – 2.0.5 SearchWP Redirects: by SearchWP – 1.4.2 WooCommerce XML feed for Skroutz & Bestprice: by Papaki – 1.6.9.1 WP All Import - User Import Add-On Pro: by Soflyy – 1.1.8 WP Rocket - D-bugger: by WP Rocket Support Team – 1.2.1 WP Snow - Best Snow Effect Plugin: by Ironikus – 1.0.2 Dropin Plugins (2) advanced-cache.php: advanced-cache.php object-cache.php: Object Cache Pro (Drop-in) Must Use Plugins (4) Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.10 Object Cache Pro (MU): by Rhubarb Group – 1.18.0 Plugin Organizer MU: by Jeff Sterup – 10.1.9 prevent-table.php: by – Settings API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space Thousand Separator: . Decimal Separator: , Number of Decimals: 2 Taxonomies: Product Types: simple (simple) grouped (grouped) variable (variable) external (external) composite (composite) Taxonomies: Product Visibility: exclude-from-search (exclude-from-search) exclude-from-catalog (exclude-from-catalog) featured (featured) outofstock (outofstock) rated-5 (rated-5) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) Connected to WooCommerce.com: – Enforce Approved Product Download Directories: – HPOS feature screen enabled: ? HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: ? WC Pages Shop base: #29019 - /shop/ Cart: #29049 - /cart/ Checkout: #29050 - /checkout/ My account: #29051 - /my-account/ Terms and conditions: #29755 - /terms/ Theme Name: FemmeFatale Version: 11.4 Author URL: https://about.gr Child Theme: ? Parent Theme Name: Botiga Parent Theme Version: 2.0.8 Parent Theme Author URL: https://athemes.com WooCommerce Support: ? Templates Overrides: /public_html/wp-content/plugins/woocommerce/templates/content-product-cat.php femmefatale/woocommerce/content-product.php Composite Products Database Version: 8.7.4 Loopback Test: ? Template Overrides: – Admin Enabled Features: activity-panels analytics coupons customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen 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: product-block-editor minified-js new-product-management-experience product-variation-management settings Daily Cron: ? Next scheduled: 2023-05-13 09:05:25 +02:00 Options: ? Notes: 119 Onboarding: completed WooCommerce PayPal Payments Onboarded: ? Shop country code: GR WooCommerce currency supported: ? Advanced Card Processing available in country: – Pay Later messaging available in country: – Webhook status: ? Vault enabled: ? Logging enabled: ? Reference Transactions: – Used PayPal Checkout plugin: – Tracking enabled: ? Local Pickup Plus Status: Disabled Geocoding: – Pickup Locations: 4 Pickup Appointments: – Pickup Location Tax: ? Checkout Display: Pickup selection mode: per orderCart item handling mode: automatic groupingDefault cart item handling: pickup items Social Login Facebook: ? Available Twitter: Disabled Google: ? Available Amazon: Disabled Linkedin: Disabled Paypal: Disabled Disqus: Disabled Vkontakte: Disabled Action Scheduler Complete: 43,743 Oldest: 2023-05-09 14:04:01 +0000 Newest: 2023-05-12 17:41:58 +0000 Failed: 530 Oldest: 2023-03-04 08:00:04 +0000 Newest: 2023-05-12 17:00:29 +0000 Pending: 7 Oldest: 2023-05-12 17:51:09 +0000 Newest: 2023-05-17 12:21:23 +0000 Status report information Generated at: 2023-05-12 19:42:36 +02:00 `
By accident I ommited to mention the error:
Automattic\WooCommerce\Database\Migrations\MetaToCustomTableMigrator->process_insert_batch, Automattic\WooCommerce\Database\Migrations\TableMigrator->db_query
Order Data Sync 100% [============================================] 0:00 / 0:00Error: Infinite loop detected, aborting.If there are any queries you would like me to run in my dataset to help you further about the order(s) that created the issue let me know.
-
This reply was modified 1 year, 9 months ago by
dimitrisv.
Ι have so more information on this issue. I couldnt find this entry on wp_wc_orders – so although HPOS was the prefered option it stopped serving it thereafter.
I found this entry 105765 in the wp_post table as follows:ID post_author post_status comment_status ping_status post_password post_modified post_modified_gmt post_content_filtered post_parent menu_order post_type 105765 1 wc-completed closed closed wc_order_VXkzrKxAVClqj 11/05/2023 12:36 11/05/2023 10:36 104724 0 shop_order_refund
Basically it was a refund instruction to order 104724
So there seems to be a bug with the refunds that you have to check.
I have notified the shop about the issue and hopefully the operator will recall on how she handled this particular order.
Also note that this order had been shipped (thus the shipment tracking plugin was utilised there as well and there may be a form of incompatibility)Shipment Tracking – WooCommerce
The shops version is 2.0.0 and possibly it is incompatible with HPOS.
I can confirm that this is the issue!
(Refunded orders with shipment tracking)
It has to do with the refunded orders that have had a packing slip attached to them. As soon as I deleted these orders the sync went ahead fine.
Please pass along this to the Shipment Tracking Plugin Team.
Cheers!-
This reply was modified 1 year, 9 months ago by
dimitrisv. Reason: resolved
Some more perspective in the use case. The user, first refunded the moneys via Paypal in both instances – that automatically reverted the status to refuned; you may have to also explore the Shipment Trackings behaviour when the refund it is done via the Paypal plugin.
I am also noticing this warning in the logs:
[Sat May 13 06:35:07.851392 2023] [proxy_fcgi:error] [pid 30048:tid 140292858558208] [client 130.43.104.91:0] AH01071: Got error 'PHP message: PHP Warning: ?Undefined array key 1 in /wp-content/plugins/woocommerce/src/Utilities/ArrayUtil.php on line 257PHP message: PHP Fatal error: ?Uncaught TypeError: Automattic\\WooCommerce\\Utilities\\ArrayUtil::deep_assoc_array_diff(): Argument #2 ($array2) must be of type array, null given, called in /wp-content/plugins/woocommerce/src/Utilities/ArrayUtil.php on line 257 and defined in /wp-content/plugins/woocommerce/src/Utilities/ArrayUtil.php:233\nStack trace:\n#0 /wp-content/plugins/woocommerce/src/Utilities/ArrayUtil.php(257): Automattic\\WooCommerce\\Utilities\\ArrayUtil::deep_assoc_array_diff()\n#1 /wp-content/plugins/woocommerce/src/Utilities/ArrayUtil.php(234): Automattic\\WooCommerce\\Utilities\\ArrayUtil::deep_compute_or_compare_array_diff()\n#2 /wp-content/plugins/woocommerce/src/Internal/DataStores/Orders/OrdersTableDataStore.php(1268): Automattic\\...', referer: https://femme-fatale.gr/wp-admin/admin.php?page=wc-admin
We are using php 8.28 and you may have to check it out.Hello @dimitrisv,
Thank you for sharing these findings; they will certainly help us gain a better understanding of what is happening.Could you please open a ticket about this from WooCommerce.com > MY profile > Support?
Make sure to include a link to this thread so we know what has been done already and to contact us from the same account linked to the Shipment Tracking extension.
Cheers! -
This reply was modified 1 year, 9 months ago by
- The topic ‘HPOS Sync Error’ is closed to new replies.