Title: Order Admin Search Error
Last modified: January 20, 2020

---

# Order Admin Search Error

 *  Resolved [Nicker_82](https://wordpress.org/support/users/nicker_82/)
 * (@nicker_82)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/order-admin-search-error/)
 * Hi,
 * After the Woocommerce 3.0 update we have problem with Order search in admin:
 * Setup:
    All plugins updated.
 * Order number custom prefix = Yes (#NT before order number)
    Enable order tracking
   by custom number: Enabled Enable order admin search by custom number: Enabled
 * If we only search for order number, we get a “WordPress database error:
    [Not
   unique table/alias:’wp_xxxxxxx_postmeta’] SELECT SQL_CALC_FOUND_ROWS DISTINCT…”
 * If search with the prefix: No results (No error message)
 * When we inactive the “Custom Order Numbers for WooCommerce” plugin and do an 
   order search with the numbers only, then it’s working.

Viewing 1 replies (of 1 total)

 *  Plugin Support [kenil802](https://wordpress.org/support/users/kenil802/)
 * (@kenil802)
 * [6 years, 3 months ago](https://wordpress.org/support/topic/order-admin-search-error/#post-12347492)
 * Hi [@nicker_82](https://wordpress.org/support/users/nicker_82/),
 * Regarding the query, I have replicated your issue on our staging site where the
   order numbers are not getting searched when the plugin is active.
 * However, I will add this issue in our Github Repository and we will get back 
   to you with an update soon.
 * Regards,
    Kenil Shah
    -  This reply was modified 6 years, 3 months ago by [kenil802](https://wordpress.org/support/users/kenil802/).

Viewing 1 replies (of 1 total)

The topic ‘Order Admin Search Error’ is closed to new replies.

 * ![](https://ps.w.org/custom-order-numbers-for-woocommerce/assets/icon-256x256.
   jpg?rev=2825614)
 * [Custom Order Numbers for WooCommerce](https://wordpress.org/plugins/custom-order-numbers-for-woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/custom-order-numbers-for-woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/custom-order-numbers-for-woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-order-numbers-for-woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-order-numbers-for-woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-order-numbers-for-woocommerce/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [kenil802](https://wordpress.org/support/users/kenil802/)
 * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/order-admin-search-error/#post-12347492)
 * Status: resolved