search

modxcms / Tagger

GNU General Public License v2.0
16 stars 31 forks source link

8000+ SQL queries #129

Open siteincity opened 4 years ago

siteincity commented 4 years ago

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 commented 3 years ago

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).