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

特定 SQL 语句导致大量报错 #818

Closed
drsanwujiang opened this issue Nov 17, 2023 · 6 comments
Closed

特定 SQL 语句导致大量报错 #818

drsanwujiang opened this issue Nov 17, 2023 · 6 comments
Labels
bug Something isn't working Stale

Comments

@drsanwujiang
Copy link

functions.php#L2063 在检查数据表时指定了数据库引擎 MyISAM。

MySQL、MariaDB 的默认引擎是 InnoDB,同时 PlanetScale 等数据库托管服务干脆取消了对 MyISAM 的支持,这会导致大量报错:

Screenshot

可以考虑删掉对数据库引擎的指定?

@drsanwujiang drsanwujiang added the bug Something isn't working label Nov 17, 2023
Copy link

@drsanwujiang,感谢你给 sakurairo 提出了 issue。ヾ(≧▽≦*)o
请根据 issue 模版确保背景信息的完善,我们将调查并尽快回复你。

@KotoriK
Copy link
Collaborator

KotoriK commented Nov 21, 2023

或许可以考虑在不支持MyISAM的环境自动fallback? @mirai-mamori

@drsanwujiang
Copy link
Author

或许可以考虑在不支持MyISAM的环境自动fallback? @mirai-mamori

有特别需要 MyISAM 的地方吗?

@KotoriK
Copy link
Collaborator

KotoriK commented Nov 22, 2023

或许可以考虑在不支持MyISAM的环境自动fallback? @mirai-mamori

有特别需要 MyISAM 的地方吗?

查了下MyISAM适合少写多读的场合,这个表是用于随机图的,应该会更适合

@bymoye
Copy link
Collaborator

bymoye commented Dec 4, 2023

考虑弃用该函数

Copy link

github-actions bot commented Jan 4, 2024

这个 Issue 已经 30 天没有任何活动了,将被标记为过时 stale。删除 stale 标签或评论,否则将在 7 天内关闭。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Stale
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants