Tagger: Group Sort Field Rank not displaying Tags

[vibedesign]

I set my Tagger group Sort Field to Rank but this results in my tags not being displayed at all when looking in the Tagger tab on the resource. It just displays the group title but no tags below to assign.

Setting Sort Field to Alias like it is by default works like expected.

Here are my exact group settings:

This looks like a bug to me, or is there something else, I have to setup here?
No errors in the log.

MODX 2.8.4.-pl
PHP 8.0

[halftrainedharry]

I tested it (same MODX & PHP versions, Tagger 1.12.0-pl), but I can’t reproduce the problem.

Is there anything special in the tag you are displaying? Maybe apostrophes or special characters in the text?

[vibedesign]

There is hyphens (-) and umlauts, but only hyphens (and no spaces) in the alias, I made sure to rewrite the umlauts in there.

I didn’t think this would be a problem, as they worked perfectly fine when sorting by alias.

[halftrainedharry]

I remembered. It’s the problem with MySQL8 where “rank” is a reserved keyword.

Here is a fix:

Tagger not showing tags or rendering assigned tags on backend

I’ve previously seen behavior like that (a count but no results) when there were invalid UTF8 characters in the content, which breaks the json generation. And also when there’s an issue with the query itself after the count which @halftrainedharry suggested. In this case I’m 92% sure the problem is sorting by rank - that’s a reserved keyword and needs special handling. Did you not get any messages about that in the MODX error log? Try replacing $c->sortby($sortField,$sortDir); with $c->sort…

[vibedesign]

Thanks that worked great in the case of displaying the tags again. It looks like the tags are now sorted by id though, and not by the given rank value.

[halftrainedharry]

@vibedesign

It looks like the tags are now sorted by id though, and not by the given rank value.

Really?
What exactly did you change in the code?

[vibedesign]

I replaced line 34 in core/components/tagger/processors/mgr/extra/gettags.class.php:

// $c->sortby($sortField,$sortDir);
$c->sortby($this->modx->quote($sortField), $sortDir);

[halftrainedharry]

It turns out, the solution from the other thread was wrong.

It should be:

$c->sortby($this->modx->escape($sortField), $sortDir);

(escape instead of quote.)