HPOS Sync Error

  • Resolved dimitrisv

    (@dimitrisv)


    1 year, 10 months ago

    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, 10 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, 10 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.