WordPress database error after update to 7.2.1
-
Hi, after updating to 7.2.1 my log is full of DB errors as follows:
WordPress database error Unknown column 'wp_postmeta.post_id' in 'where clause' for query SELECT meta_id FROM ***_postmeta,
(SELECT DISTINCT post_id FROM ***_postmeta
WHERE (meta_key = '_billing_country' OR meta_key='_shipping_country')?AND meta_value='UA')
AS states_in_country
WHERE (meta_key='_billing_state' OR meta_key='_shipping_state')
AND meta_value='DT'
AND wp_postmeta.post_id = states_in_country.post_id
LIMIT 100 made by do_action('wp_ajax_as_async_request_queue_runner'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Async_Request->maybe_handle, ActionScheduler_AsyncRequest_QueueRunner->handle, do_action('action_scheduler_run_queue'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array('woocommerce_run_update_callback'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::run_update_callback, wc_update_721_adjust_ukraine_states, Automattic\WooCommerce\Database\Migrations\MigrationHelper::migrate_country_states, Automattic\WooCommerce\Database\Migrations\MigrationHelper::migrate_country_states_for_orders
At seems you usedwpas hard-coded prefix instead of using actual DB prefix.
- The topic ‘WordPress database error after update to 7.2.1’ is closed to new replies.
