Tagger icon indicating copy to clipboard operation
Tagger copied to clipboard

8000+ SQL queries

Open siteincity opened this issue 5 years ago • 1 comments

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

siteincity avatar Jul 03 '20 11:07 siteincity

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

Mark-H avatar Apr 30 '21 12:04 Mark-H