Database error: Expression #24 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'virtuamg_basedata.products_categories.position' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
Invalid query: SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, products.tracking, products.feature_comparison, products.zero_price_action, products.product_type, products.tax_ids, products.weight, GROUP_CONCAT(IF(products_categories.link_type = 'M', CONCAT(products_categories.category_id, 'M'), products_categories.category_id)) as category_ids, min_qty, max_qty, products.qty_step, products.list_qty_count, products.is_edp, avail_since, buy_in_advance, products.product_code, products.amount, MIN(prices.price) as price, products.status, products.list_price, descr1.short_description, IF(descr1.short_description = '', descr1.full_description, '') as full_description, products_categories.position, cscart_seo_names.name as seo_name, popularity.total as popularity FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ES' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price AND prices_2.usergroup_id IN (0, 0, 1) INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND products.status IN ('A') LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'ES' LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1 AND cscart_categories.category_id IN (165, 192, 188, 183, 179, 197, 215, 217, 219, 228, 271, 284, 214, 193, 187, 189, 184, 170, 198, 213, 218, 220, 230, 191, 185, 173, 194, 221, 226, 175, 195, 196, 216, 222, 227, 272, 178, 223, 232, 278, 176, 224, 225, 281, 229, 171, 231, 180, 280, 174, 172, 181, 177, 275, 273, 276, 295, 296) AND prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL GROUP BY products.product_id ORDER BY popularity.total desc LIMIT 0, 10


Backtrace:
File:/home/virtuamgco/public_html/core/fn.database.php
Line:310
Function:db_error
File:/home/virtuamgco/public_html/core/fn.database.php
Line:37
Function:db_query
File:/home/virtuamgco/public_html/core/fn.catalog.php
Line:3154
Function:db_get_array
File:/home/virtuamgco/public_html/controllers/customer/categories.php
Line:66
Function:fn_get_products
File:/home/virtuamgco/public_html/core/fn.control.php
Line:530
Function:include
File:/home/virtuamgco/public_html/core/fn.control.php
Line:393
Function:fn_run_controller
File:/home/virtuamgco/public_html/index.php
Line:27
Function:fn_dispatch