SQL SYNTAX ERROR
Query SQL: select * from ckc_category,ckc_product where ckc_category.category_id = ckc_product.category_id and ckc_category.category_publish = '1' and ckc_product.product_publish = '1' and ckc_product.product_featu = '1' group by ckc_category.category_id order by ckc_category.category_order asc limit 5
Error Number: 1055 Expression #9 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ducvietnamvn_web.ckc_product.product_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Date: Sun, September 27, 2020 14:19:36
IP: 3.234.143.26
Browser: CCBot/2.0 (https://commoncrawl.org/faq/)
Script: /?option=com_product&cat=3&sub=3
Referer:
PHP Version : 5.3.29
OS: Linux
Server: LiteSpeed
Server Name: ducvietnam.vn