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

8000+ SQL queries #129

Open
siteincity opened this issue Jul 3, 2020 · 1 comment
Open

8000+ SQL queries #129

siteincity opened this issue Jul 3, 2020 · 1 comment

Comments

@siteincity
Copy link

when saving a document, it generates a huge number of queries to the database,
2020-07-03_15-13-51

phpMyAdmin - queries
2020-07-03_15-19-34

and admin panel freezes at the same time as in the screenshot
2020-07-03_15-14-08

I tried to disable all plugins except tagger

mysql-10.3.21
MODX Revolution 2.7.1-pl
tagger-1.11.0-pl

in Russian, tagger, does not want to generate alias automatically
2020-07-03_15-24-05

@Mark-H
Copy link

Mark-H commented Apr 30, 2021

My guess: it's getting stuck in this loop because it can't generate the alias and you already have another tag with an empty alias.

So when the cleanAlias method returns a proper result for your russian options, the problem with the queries will go away.

Try enabling the core transliteration with the translit extra (or a different one, I think modstore may have an alternative).

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