-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.4.42
-- Error-message(debug-mod must be tuned on) -- : 1140
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause SQL=SELECT DISTINCT b.product_id,max(b.familia) as max_testfamilia_3, min(b.familia) as min_testfamilia_3 FROM nvb4t_hikashop_product_category AS a LEFT JOIN nvb4t_hikashop_product AS b ON a.product_id=b.product_id WHERE b.product_published=1 AND b.product_type = 'main' AND a.category_id IN (12,18,19,2) AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') ORDER BY a.ordering ASC
Hello, I´m trying to use filters in the site and when I turn on the module the page have an error. Could you help me. Regards,
Leo.