今天在做项目时,获取数据返回列表时发生报错:
Syntax error or access violation: 1055 'user_sign.addtime' isn't in GROUP BY (SQL: SELECT addtime,flag FROM user_sign WHERE uid = 56 AND type = 0 AND addtime > 1525104000 AND addtime < 1527782399 GROUP BY FROM_UNIXTIME(addtime,'%Y%m%d') ORDER BY addtime ASC)
但是,把sql语句放到放到数据库中执行就没问题!
查了一下,发现laravel中config/database.php配置中
strict 严格模式 它的值由true改为false就解决了问题