Plugin Author
BlueGlass
(@blueglassinteractive)
Hello @thleruth,
can you please describe a bit more and maybe share an url?
as we tested this on our testing envirenment and havent noticed issue in search between woocomemrce and jobs for wordpress plugin
Best wishes
Hey @blueglassinterctative,
Thank you for fast follow up.
Basically, with the plugin running trying to pull any order via the search function of Woocommerce leads to no order popping up (like if no orders was matching the searched elements) even tho some orders should come up. I digged into it when it happened and it came from a bad sql query that only happens when the plugin is activated. I also quickly tried to strip all the other plugins but woocommerce and yours but sadly it persisted.
At the moment, I can’t pull the exact bad sql query as I was doing that on my live enviroment and trying to quickly debug it.
I will test it again and our staging in the coming days and I will post for you screenshot of what is happening and also the sql issue coming from it.
Hopefully we can fix it together because I really liked your plugin until that 😀
Have a nice day!
Hey guys,
Sorry for the super long wait. I have been busy with other issues. I have added our current install in a sandbox environment stripped all our plugins but woocommerce (3.4.5), a php error logger, and your plugin. Sadly the issue is still there.
As a reminder, if I search in woocommerce for orders (wooocommerce – orders) via the search function, no orders is ever found even tho the string I am passing should lead to some results. Deactivating your plugin and re-running the search works.
Here is the error that is logged.
Log
“WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘))) AND wp_posts.post_type = ‘shop_order’ AND ((wp_posts.post_status = ‘wc-pend’ at line 1 for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (27393,27397,0) AND ((())) AND wp_posts.post_type = ‘shop_order’ AND ((wp_posts.post_status = ‘wc-pending’ OR wp_posts.post_status = ‘wc-processing’ OR wp_posts.post_status = ‘wc-on-hold’ OR wp_posts.post_status = ‘wc-completed’ OR wp_posts.post_status = ‘wc-cancelled’ OR wp_posts.post_status = ‘wc-refunded’ OR wp_posts.post_status = ‘wc-failed’)) ORDER BY wp_posts.post_date DESC LIMIT 0, 20 made by WP_Posts_List_Table->prepare_items, wp_edit_posts_query, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts”
Do you have any idea where it could be from?
Plugin Author
BlueGlass
(@blueglassinteractive)
Hi @thleruth
Sory for long delay with an answer. You can update the plugin now and issue should be resolved 🙂
Thank you guys. Tested on our staging, looks all good. I am moving it production. Thank you for that 🙂
