按照小白文档安装好,2.3.7,照教程安装后,什么都没动过,未安装manggoDb
搜索栏搜索报数据库错误
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fecmall.full_search_product.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
The SQL being executed was: SELECT * FROM full_search_product
WHERE ((name
LIKE '%1%') OR (description
LIKE '%1%')) AND (status
=1) AND (lang
='en') GROUP BY spu
ORDER BY score
DESC LIMIT 30