部署完成之后，打开web端之后，点击工作台报错

MeterSphere
1

image
image1265×165 49 KB

Error querying database. Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘metersphere.urr.create_time’ which is not in SELECT list; this is incompatible with DISTINCT ### The error may exist in io/metersphere/project/mapper/ExtProjectMemberMapper.xml ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT distinct u.id AS id,urr.source_id from user_role_relation urr join user u on urr.user_id = u.id where urr.source_id in (select p.id from project p where p.organization_id = ? and p.enable = 1 and p.deleted = 0 ) and u.deleted = 0 and u.enable = 1 order by urr.create_time desc ### Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘metersphere.urr.create_time’ which is not in SELECT list; this is incompatible with DISTINCT ; uncategorized SQLException; SQL state [HY000]; error code [3065]; Expression #1 of ORDER BY clause is not in SELECT list, references column ‘metersphere.urr.create_time’ which is not in SELECT list; this is incompatible with DISTINCT

2

https://metersphere.io/docs/v3.x/dev_manual/dev_manual/ 你这个是数据库配置问题，按照官网数据库的配置就可以了