请在此详细描述你所遇到的问题
【产品名称】:多商户 JAVA版
【部署环境】:例:本地环境 / 线上环境
【Mysql版本】::5.7
【使用终端】: H5
首页报错。
com.zbkj.service.service.impl.SeckillActivityTimeServiceImpl.findActivityByDateTime --根据时间获取秒杀活动 ,
findActivityByDateTime 这个方法是这也写的
/** * 根据时间获取秒杀活动
* @return 秒杀活动ID列表
*/@Override
public List<Integer> findActivityByDateTime(Integer dateInt, Integer timeInt) {
LambdaQueryWrapper<SeckillActivityTime> lqw = Wrappers.lambdaQuery();
lqw.select(SeckillActivityTime::getId, SeckillActivityTime::getSeckillId);
lqw.le(SeckillActivityTime::getStartDate, dateInt);
lqw.ge(SeckillActivityTime::getEndDate, dateInt);
lqw.le(SeckillActivityTime::getStartTime, timeInt);
lqw.ge(SeckillActivityTime::getEndTime, timeInt);
lqw.groupBy(SeckillActivityTime::getSeckillId);
List<SeckillActivityTime> timeList = dao.selectList(lqw);
return timeList.stream().map(SeckillActivityTime::getSeckillId).collect(Collectors.toList());
}
它执行出的sql是这样的
SELECT id,seckill_id FROM eb_seckill_activity_time WHERE (start_date <= ? AND end_date >= ? AND start_time <= ? AND end_time >= ?) GROUP BY seckill_id
报错如下:
### Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_seckill_activity_time.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crmeb.eb_seckill_activity_time.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
这是哪里有问题呢?
{{item.user_info.nickname ? item.user_info.nickname : item.user_name}} 作者 管理员 企业
{{itemc.user_info.nickname}}
{{itemc.user_name}}
回复 {{itemc.comment_user_info.nickname}}