Recurring PHP errors in log every few seconds

  • Every few secs we are seeing this recurring PHP error in the error logs. Two questions – 1) Is it anything to worry about, and 2) How do I fix it?

    [07-May-2020 13:25:14 UTC] WordPress database error Column ‘product_id’ cannot be null for query REPLACE INTO wpgg_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 (16529, 23475, NULL, 0, 4616, 2, 42.360000, ‘2019-07-22 18:57:37’, 0.000000, 0.000000, 25.980000, 0.000000, 68.340000) 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(‘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

    [07-May-2020 13:25:13 UTC] WordPress database error Column ‘product_id’ cannot be null for query REPLACE INTO wpgg_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 (17733, 24290, NULL, 0, 4941, 2, 42.220000, ‘2019-09-11 20:51:13’, 0.000000, 0.000000, 30.000000, 0.000000, 72.220000) 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(‘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)
  • Plugin Support AW a11n

    (@slash1andy)

    Automattic Happiness Engineer

    Hey there!

    This seems to be related to a PHP hook that’s not a part of WooCommerce itself: wpgg_wc_order_product_lookup

    That is likely coming from a plugin made for WooCommerce that’s not been updated in a bit. I would check on your plugins list for likely suspects, or you can try with running the full conflict test:

    This kind of problem is usually caused by either a conflict with your theme or with another plugin.
    ?
    The best way to determine this is to:

    • Temporarily switch your theme to Storefront
    • Disable all plugins except for WooCommerce
    • Repeat the action that is causing the problem

    If you’re not seeing the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To figure out which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.

    Thread Starter CGain

    (@cgain)

    Thanks AW! Would ticking the ‘null’ box in the table in phpmyadmin help?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Recurring PHP errors in log every few seconds’ is closed to new replies.

Tags