please open section “Misc Settings”, mark “Enable debug output” , press Preview.
run phpMyAdmin and test SQLs
Here’s the preview:
SELECT ID AS order_id FROM cctv24posts AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.ID >= 519456 AND orders.ID <= 0 AND orders.post_status in (‘wc-pending’,’wc-processing’,’wc-on-hold’,’wc-completed’) AND orders.post_status NOT in (‘auto-draft’,’trash’)
SQL results: https://prnt.sc/jGdmZGlx6e_x
Orders: https://prnt.sc/NCbuQF0OGDVl
please, remove space from filter “Orders Ids”.
2nd value is not empty
I have tried both
SELECT ID AS order_id FROM cctv24posts AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.ID >= 519456 AND orders.ID <= 519410 AND orders.post_status in (‘wc-pending’,’wc-processing’,’wc-on-hold’,’wc-completed’) AND orders.post_status NOT in (‘auto-draft’,’trash’)
and
SELECT ID AS order_id FROM cctv24posts AS orders WHERE orders.post_type in ( ‘shop_order’) AND 1 AND orders.ID>= 519456 AND orders.ID<= 519410 AND orders.post_status in (‘wc-pending’,’wc-processing’,’wc-on-hold’,’wc-completed’) AND orders.post_status NOT in (‘auto-draft’,’trash’)
Still getting nothing?
please, run phpMyAdmin , review records in table cctv24posts
Do they have correct values in columns post_type and post_status
I just purchased a license for the pro version, would your support be able to troubleshoot if I open a ticket?
Outdated versions don’t support HPOS mode .
The problem was solved by updating the plugin.
