DB error

  • Resolved ITCS

    (@dimath99)


    5 years, 1 month ago

    Hi,

    I see this error:

    WordPress database error Column ‘variation_id’ cannot be null for query REPLACE INTO wp_wc_order_product_lookup (order_item_id, order_id, product_id, variation_id, customer_id, product_qty, product_net_revenue, date_created, coupon_amount, tax_amount, shipping_amount, shipping_tax_amount, product_gross_revenue) VALUES (1404, 41668, 0, NULL, 392, 1, 33.810000, ‘2015-08-14 11:46:22’, 0.000000, 0.000000, 0.000000, 0.000000, 33.810000) made by do_action_ref_array(‘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(‘wc-admin_import_orders’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Schedulers\ImportScheduler::do_action_or_reschedule, call_user_func_array, Automattic\WooCommerce\Admin\Schedulers\OrdersScheduler::import, Automattic\WooCommerce\Admin\API\Reports\Products\DataStore::sync_order_products

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hello @dimath99,

    Could you let me know what was happening on the site when this error appeared? Some additional context would be helpful in finding out what’s happening. Also, could you please send me a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, you can paste it here.

    Thanks!

    Hi @dimath99,

    We have not heard from you in a while so I will close this thread. If you continue to have issues please open a new thread!

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB error’ is closed to new replies.