Attribute Terms Not displaying for updates

  • Resolved Saravana Kumar K

    (@mycholan)


    7 years, 8 months ago

    WP both 4.6 & 4.5.3
    WC 2.6.4
    Ubuntu 16.04
    MySql 5.7

    I am able to add new Product Attributes ( Lets say Size )
    I am able to add terms for Attrinutes ( Lets say Large, Medium … )
    After the above two steps if I visit edit-tags.php page ( http://localhost/wp/wp-admin/edit-tags.php?taxonomy=pa_size&post_type=product ) Its says “No Size Found” and yet it shows correct count 3 Items ( as I inserted three option under Size )

    I am getting the following error mesage on Apache error.log file

    WordPress database error Expression #1 of ORDER BY clause is not in SELECT list, references column 'wp.tm.meta_value' which is not in SELECT list; this is incompatible with DISTINCT for query SELECT DISTINCT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN wp_termmeta AS tm ON (t.term_id = tm.term_id AND tm.meta_key = 'order_pa_size') WHERE tt.taxonomy IN ('pa_size') ORDER BY tm.meta_value+0 ASC, t.name ASC made by wp_dropdown_categories, get_terms, referer: http://localhost/wp/wp-admin/edit.php?post_type=product&page=product_attributes

    Some thing wrong with my MySql configuration.?

    https://wordpress.org/plugins/woocommerce/

Viewing 1 replies (of 1 total)
  • Thread Starter Saravana Kumar K

    (@mycholan)

    7 years, 8 months ago

    Found the fix, it’s due to MySQL 5.7 change

    Use the following query to fix it. ( you will have to be mysql root user )

    SET GLOBAL sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Viewing 1 replies (of 1 total)
  • The topic ‘Attribute Terms Not displaying for updates’ is closed to new replies.