Title: Th.leruth's Replies | WordPress.org

---

# Th.leruth

  [  ](https://wordpress.org/support/users/thleruth/)

 *   [Profile](https://wordpress.org/support/users/thleruth/)
 *   [Topics Started](https://wordpress.org/support/users/thleruth/topics/)
 *   [Replies Created](https://wordpress.org/support/users/thleruth/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/thleruth/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/thleruth/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/thleruth/engagements/)
 *   [Favorites](https://wordpress.org/support/users/thleruth/favorites/)

 Search replies:

## Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Job Postings] [Feature Request] Private Notes on applications](https://wordpress.org/support/topic/feature-request-private-notes-on-applications/)
 *  Thread Starter [Th.leruth](https://wordpress.org/support/users/thleruth/)
 * (@thleruth)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/feature-request-private-notes-on-applications/#post-11778315)
 * We are also in the EU and I am actually familiar with the whole regulation (well
   I thought ahah). However, I never saw keeping data on our database linked to 
   our install as an issue (obviously as long as we don’t have a security breach).
   Our database access is secured and so is our back end access to our install. 
   Am I missing something?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Job Postings] [Feature Request] Private Notes on applications](https://wordpress.org/support/topic/feature-request-private-notes-on-applications/)
 *  Thread Starter [Th.leruth](https://wordpress.org/support/users/thleruth/)
 * (@thleruth)
 * [6 years, 9 months ago](https://wordpress.org/support/topic/feature-request-private-notes-on-applications/#post-11777148)
 * No rush at all. It is just an idea 🙂
    I have tried with comments but without
   success. Could definitely play with post meta and update a bit the Job entry 
   page template but I thought I would not mess with it if you guys think it is 
   a good idea and would implement it at some point. At the moment, we do it the
   old school way and have an extra file we keep externally with all the info.
 * Good luck fixing the other issue.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Job Postings] Compatibility with Woocommerce](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/)
 *  Thread Starter [Th.leruth](https://wordpress.org/support/users/thleruth/)
 * (@thleruth)
 * [7 years, 4 months ago](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/#post-11018437)
 * Marking as solved
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Job Postings] Compatibility with Woocommerce](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/)
 *  Thread Starter [Th.leruth](https://wordpress.org/support/users/thleruth/)
 * (@thleruth)
 * [7 years, 4 months ago](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/#post-11018436)
 * Thank you guys. Tested on our staging, looks all good. I am moving it production.
   Thank you for that 🙂
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Job Postings] Compatibility with Woocommerce](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/)
 *  Thread Starter [Th.leruth](https://wordpress.org/support/users/thleruth/)
 * (@thleruth)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/#post-10939082)
 * 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?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Job Postings] Compatibility with Woocommerce](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/)
 *  Thread Starter [Th.leruth](https://wordpress.org/support/users/thleruth/)
 * (@thleruth)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/compatibility-with-woocommerce-17/#post-10843417)
 * 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!

Viewing 6 replies - 1 through 6 (of 6 total)