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.
