• Resolved dimitrisv

    (@dimitrisv)


    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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • 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

    Thread Starter dimitrisv

    (@dimitrisv)

    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
    `
    Thread Starter dimitrisv

    (@dimitrisv)

    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.
    Thread Starter dimitrisv

    (@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.

    Thread Starter dimitrisv

    (@dimitrisv)

    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
    Thread Starter dimitrisv

    (@dimitrisv)

    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.

    Saif

    (@babylon1999)

    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!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘HPOS Sync Error’ is closed to new replies.