这个报错是什么原因,把 sql 语句复制到数据库又没有问题。
"SQLSTATE[42000]: Syntax error or access violation: 1055 'hw_wap.wap_g.goods_name' isn't in GROUP BY (SQL: select wap_g.goods_name,COALESCE(SUM(wap_o.order_total_price),0) AS order_total_price,SUM(wap_d.goods_quantity) as goods_quantity from wap_orders
as wap_o
left join wap_orders_details
as wap_d
on wap_o
.id
= wap_d
.orders_id
left join wap_goods
as wap_g
on wap_g
.id
= wap_d
.goods_id
where (wap_o
.uniacid
= 1) and wap_o
.add_time
between 1546300800 and 1577664000 group by wap_d
.goods_id
order by wap_o
.order_total_price
desc limit 10 offset 0)"
推荐文章: