Support » Plugin: WooCommerce » WordPress database error after update to 7.2.1

  • Resolved titsmaker

    (@titsmaker)


    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 used wp as hard-coded prefix instead of using actual DB prefix.

Viewing 10 replies - 1 through 10 (of 10 total)
Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WordPress database error after update to 7.2.1’ is closed to new replies.