安装锦中智慧学工管理系统可能遇到的问题及解决办法

## 在某些操作系统下（如银河麒麟操作系统）运行jar包时，有时报redis 127.0.0.1:6379错误，或者出现类似：[/data/xuegong.jar!/BOOT-INF/classes!/license/License.xml] not a exist! 的错误
### 原因：这是由于配置文件的加载顺序原因引起的错误。参见：https&#058;//blog.csdn.net/inthat/article/details/105240468

### 解决办法：用命令行参数启动时，强制指定配置文件，命令行：
`nohup java -jar -Dfile.encoding=UTF-8 -Duser.timezone=GMT+8 xuegong.jar --spring.config.location=/data/application.yml >xuegong.log 2>&1 &`

## 界面上提示类似以下错误：

Error querying database. Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xuegong.dict.dict_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by ### The error may exist in class path resource [org/springblade/modules/desk/mapper/StatsMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT dict.dict_value AS name, COUNT(stu.id) AS value FROM xs_student stu INNER JOIN blade_dict_biz dict ON stu.xbm = dict.dict_key AND dict.tenant_id = '000000' WHERE dict.code = 'xbm' GROUP BY stu.xbm ORDER BY value DESC ### Cause: java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xuegong.dict.dict_value' 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 'xuegong.dict.dict_value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

### 原因及解决办法见：https://www.cnblogs.com/baby123/p/10631936.html

实测在Ubuntu 22.04 操作系统下 可以解决该问题，实际操作时，可以先在mysql控制台通过 select @@global.sql_mode 查看一下，并复制那一长串的sql_mode ，然后去掉 ONLY_FULL_GROUP_BY,其余部分为正确的sql_mode，然后按照链接里提示的永久解决办法替换一下实际的sql_mode。比如本文在解决该问题时，sql_mode实际为：
STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION