Support » Plugin: WooCommerce » product category list not showing in admin panel

  • Resolved ramji15788


    My php version 7.2 with ngnx server and mysql version 8.0.16 and latest wp and woocommerce version,
    Not showing category list in admin panel, see error below

    WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list, references column ‘wordpress.wp_termmeta.meta_value’ which is not in SELECT list; this is incompatible with DISTINCT]
    SELECT DISTINCT t.*, tt.* FROM wp_terms AS t LEFT JOIN wp_termmeta ON ( t.term_id = wp_termmeta.term_id AND wp_termmeta.meta_key=’order’) INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘product_cat’) AND ( ( wp_termmeta.meta_key = ‘order’ OR wp_termmeta.meta_key IS NULL ) ) ORDER BY wp_termmeta.meta_value+0 ASC, ASC

    Please help

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Laurena Rehbein


    Automattic Happiness Engineer

    Hi @ramji15788,

    This sounds like a conflict – have you tested to rule that out? To do this, you would temporarily switch to a default theme (Storefront, or Twenty Nineteen) and deactivate all other plugins, and see if the trouble still happens.

    If it works well with the default installation, you would then slowly re-enable everything until you can pinpoint the troublemaker.

    Plugin Support RK


    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘product category list not showing in admin panel’ is closed to new replies.