halo二次改动报错笔记

215 次访问 2021-03-02

qiwuhedy

/*自定义jar依赖*/
    compile 'com.github.penggle:kaptcha:2.3.2'
    compile 'com.nimbusds:nimbus-jose-jwt:7.1'
    compile 'com.alibaba:fastjson:1.2.75'
    compile("org.springframework.boot:spring-boot-starter-data-redis:2.3.2.RELEASE")
    compile("redis.clients:jedis:2.9.3")

一、MYSQL

1、GROUP BY报错

of SELECT list is not in GROUP BY clause and contains nonaggregated column 'halodb.a.gains' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

解决
1、sudo vim /etc/mysql/conf.d/mysql.cnf
2、sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
3、sudo service mysql restart