Order Admin Search Error

  • Resolved Nicker_82

    (@nicker_82)


    5 years, 2 months ago

    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

    (@kenil802)

    Hi @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 5 years, 2 months ago by kenil802.
Viewing 1 replies (of 1 total)
  • The topic ‘Order Admin Search Error’ is closed to new replies.