Critical Error when attempting to view the Woocommerce Orders screen

  • Resolved cmpellison

    (@cmpellison)


    3 years, 3 months ago

    After updating to version 1.3.2, the Orders screen is no longer accessable – we get a white screen, with ‘A Critical Error has ocurred on your site…..” Checking the error logs and the WP_error_logs, it seems there is a database call that is returning an fatal error -> WordPress database error Got error ’empty (sub)expression’ from regexp for query. This persists even when I deactivate the plugin itself.

    I can provide more log information. This is a huge problem.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter cmpellison

    (@cmpellison)

    The actual error reported is:

    [03-Aug-2021 18:55:29 UTC] WordPress database error Got error 'empty (sub)expression' from regexp for query 
			SELECT 
				posts.post_status as ordr_status,
				posts.ID AS order_id
			FROM wp_posts AS posts								
			WHERE 				
				posts.post_type LIKE 'shop_order'
				AND posts.post_status IN ('wc-shipped')
				
				AND posts.ID IN (SELECT wp_woocommerce_order_items.order_id FROM wp_woocommerce_order_items WHERE order_item_type = 'shipping' 
				AND order_item_name NOT LIKE 'Local Pickup%'
				AND order_item_name REGEXP '' )		
					
				ORDER BY order_id DESC				
				LIMIT 0,10 made by do_action('wp_ajax_get_unfulfilled_orders'), WP_Hook->do_action, WP_Hook->apply_filters, AST_PRO_Fulfillment_Dashboard->get_unfulfilled_orders

    The last order_item_name accordging to the class for the fulfillment dashboard is supposed to be a shipping_method but nothing is returned.

    @cmpellison were you able to get around this?

    Plugin Author Zorem

    (@zorem)

    Hi,

    I could not replicate your issue, it might be a conflict with one of your plugins. you can try to deactivate all your plugins and keep only AST and WooCommerce, clear your browser cache and then check again. if it is solved, activate your plugins one by one to find the one that creates the conflict.

    Thanks,

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Critical Error when attempting to view the Woocommerce Orders screen’ is closed to new replies.