The problem with non-Latin header resource names MODx 3.0.0

Support
1

Summary

I have template names that are used on the site that contain non-Latin names (Cyrillic, etc.), after updating them it became impossible to edit

Step to reproduce

Go to the resources, create a template with a non-Latin name. You get the inability to edit. UTF-8 encoding was used

Observed behavior

Новый проект
Новый проект1280×720 98 KB

Expected behavior

Normal characters, not question marks, should have been displayed and the content edited.

Environment

MODx 3.0.0
PDO support:

enabled

PDO drivers:

dblib, firebird, mysql, pgsql, sqlite

PDO Driver for MySQL:

enabled

Client API version: mysqlnd 7.4.16

Directive: Local Value,Master Value

pdo_mysql.default_socket: /var/run/mysqld/mysqld.sock,/var/run/mysqld/mysqld.sock

default_charset:
UTF-8

2

I can’t reproduce this problem.
Was is the collation of your database?

3

mysqlnd 7.4.16. It has happened after updates from 2.8.3… I had several templates with name “Главный template”, “Статья с тегами”

4

I was interested in the collation or charset of your database. Something like utf8mb4_general_ci or latin1_swedish_ci.

As i wrote, I can’t reproduce the issue.
This doesn’t seem to be a general problem, but something specific in your setup.

Screenshot 2022-04-03 at 13-33-17 Шаблон Статья с тегами MODX Revolution

If you look at the values directly in the database (table modx_site_templates). Are the values in the column templatename correct?

5

utf8mb4_unicode_ci
UTF-8 Unicode (utf8)
Apache/2.2.29 (Gentoo) mod_dp/0.99.7 PHP/5.6.40
libmysql - 5.6.43-84.3
The names in database incorrect too

6

If you fix the names directly in the database, does it work then?

7

Yes, but there can be a lot of such elements, why didn’t the conversion take place fully?

8

What did you do before the problem occured?

  • Have you updated MODX from an older version? From what version?
  • Have you changed the collation of the database? How did you change it?
9

2.8.2->2.8.3 then filling the site with content, then installing 3.0.0 as an upgrade. I did not change anything, as I put it during installation, and it remained

10

I tried to reproduce the issue again (including running the MODX upgrade), but everything works as expected.
It’s hard to say, what failed on your system, if I can’t reproduce it.

Does this only affect the table modx_site_templates or other tables with cyrillic content as well?

Does this mean you are still using PHP 5.6?
I think the required mininum is now PHP 7.2.5.

11

Hmm, strange, in the hosting settings Apache 2.4 + PHP 7.4 opcache and this is phpinfo

12

Versions are coming, but the problem has remained as it was

13

It might also be a MySQL configuration issue: Characters appear as question marks using MySQL | Confluence | Atlassian Documentation

Do you have access to the server? Or maybe contact the server administrator to check this out for you.

14

Thanks, bro! It has helped me

1 Like
15

This topic was automatically closed 2 days after discussion ended and a solution was marked. New replies are no longer allowed. You can open a new topic by clicking the link icon below the original post or solution and selecting “+ New Topic”.