Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

新版本,兼容Mysql、PostgreSQL、Sqlite 非管理员用户,登录获取菜单有问题 #159

Open
wuxx5321 opened this issue Jan 23, 2024 · 4 comments

Comments

@wuxx5321
Copy link

报以下错误
Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'coo-admin.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

src/modules/base/service/sys/menu.ts
125:10
// find.groupBy('a.id');
不注释GROUP BY子句 a.id
数据库版本8.2.0
默认配置默认,无修改sql-modl模式

@lu9944
Copy link

lu9944 commented Jan 31, 2024

我也出现这个问题了,是新建用户,然后登录的时候出现的

@lu9944
Copy link

lu9944 commented Jan 31, 2024

报以下错误 Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'coo-admin.b.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

src/modules/base/service/sys/menu.ts 125:10 // find.groupBy('a.id'); 不注释GROUP BY子句 a.id 数据库版本8.2.0 默认配置默认,无修改sql-modl模式

好兄弟,请参考这个链接修改
https://www.cnblogs.com/zjfjava/p/15120260.html
image

@wuxx5321
Copy link
Author

wuxx5321 commented Feb 3, 2024

我不修改mode模式,自己重写了那段代码了

@lu9944
Copy link

lu9944 commented Feb 3, 2024

我不修改mode模式,自己重写了那段代码了

真有你的,哈哈哈哈

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants