运费模板查询出错的解决方式
因数据库版本原因 5.7.27 导致group by 语句不被识别
错误提示如下图
![](https://cdn.jsdelivr.net/gh/xbdazz/mypic/img/202112221515308.png)
解决方法
//编辑my.cnf文件
vim /etc/my.cnf
//在[mysqld]下面添加一行,图下图
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
![](https://cdn.jsdelivr.net/gh/xbdazz/mypic/img/202112221515309.png)
重启mysql即可
app启动后报如下错误
![](/uploads/crmebjavalandmer/crmebjavamer/20230712/6c8be2de63b83262972f59b4374be683.png)
解决办法同上面一样