Boxes, Labels, Pouches & Bags

user warning: Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'megafort_drupalcms.term_data.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT DISTINCT(node.nid) AS nid, node_data_field_in_stock.field_in_stock_value AS node_data_field_in_stock_field_in_stock_value, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, uc_product_stock.stock AS uc_product_stock_stock, draggableviews_structure_node0.value AS draggableviews_structure_node0_value, uc_products.ordering AS uc_products_ordering FROM node node LEFT JOIN content_field_in_stock node_data_field_in_stock ON node.vid = node_data_field_in_stock.vid LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN uc_product_stock uc_product_stock ON node.nid = uc_product_stock.nid LEFT JOIN draggableviews_structure draggableviews_structure_node0 ON node.nid = draggableviews_structure_node0.nid AND (draggableviews_structure_node0.delta = 0 AND draggableviews_structure_node0.view_name = 'product_catalog' AND draggableviews_structure_node0.args = '') LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( (node.status = 1) AND (node.type in ('master', 'product')) AND (node.vid IN ( SELECT tn.vid FROM term_node tn LEFT JOIN term_hierarchy th ON th.tid = tn.tid LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid WHERE tn.tid = 9 OR th1.tid = 9 )) )GROUP BY nid ORDER BY draggableviews_structure_node0_value ASC, uc_products_ordering ASC in /home/megafort/public_html/sites/all/modules/views/includes/view.inc on line 814.