[ad_1]
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.