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

Cyrillic url are handled incorrectly #15829

Closed
nagulka opened this issue Apr 19, 2020 · 7 comments
Closed

Cyrillic url are handled incorrectly #15829

nagulka opened this issue Apr 19, 2020 · 7 comments
Labels
c: i18n For issues around internationalisation and localisation.

Comments

@nagulka
Copy link

nagulka commented Apr 19, 2020

Hi,
Cyrillic url are handled incorrectly. You can see the log. You can see that in the log snippet
matomo-error

@sgiehl
Copy link
Member

sgiehl commented Apr 19, 2020

@nagulka could you paste the url or at least the part here in the issue that causes the problem?
This might be fixed with #15618 in Matomo 4

@Findus23 Findus23 added the c: i18n For issues around internationalisation and localisation. label Apr 19, 2020
@nagulka
Copy link
Author

nagulka commented Apr 20, 2020

all Cyrillic parts of a URL, they have for example a cyrillic letter "с" or "я" cause the error and ignored from matomo.

The paths for example:
/наследие
/пять

You can see that, if you open the log file with the notepad++ (format UTF8)

@sgiehl
Copy link
Member

sgiehl commented Apr 20, 2020

Tried tracking an url containing your examples locally and it worked correctly.
Might be an issue of database collation. Could you check which collation your database and the table matomo_log_action has on your install?

@nagulka
Copy link
Author

nagulka commented Apr 20, 2020

The collation of the database (MariaDB) is utf8_general_ci, of the table matomo_log_action also utf8_general_ci. The database is auto created while matomo installation.

@nagulka
Copy link
Author

nagulka commented Apr 23, 2020

Were you able to reproduce the error?
I think that cannot be due to the collation of the database, because "Action name" is entered in the table "matomo_log_action" without any problems (even if the string contains the cyrillic letters "с" or "я"). But the "Action URL" cause the error as soon as the url contains cyrillic letters "с" or "я". I think the URL was previously converted to the wrong format (bevor the inserting in the database).

I use Matomo 3.13.4
Windows Server 2019
IIS 10
PHP-7.4.4

I am always available for additional information. Thanks.

@sgiehl
Copy link
Member

sgiehl commented Apr 24, 2020

Actually I was not able to reproduce when I send those chars in the URL. Are you able to find those requests to matomo.php in the access log? Maybe they are already sent malformed

@mattab
Copy link
Member

mattab commented Dec 11, 2023

Thanks for contributing to this issue. As it has been a few months since the last activity and we believe this is likely not an issue anymore, we will now close this. If that's not the case, please do feel free to either reopen this issue or open a new one. We will gladly take a look again!

Also this might help: https://matomo.org/faq/how-to-update/how-to-convert-the-database-to-utf8mb4-charset/

@mattab mattab closed this as not planned Won't fix, can't repro, duplicate, stale Dec 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
c: i18n For issues around internationalisation and localisation.
Projects
None yet
Development

No branches or pull requests

5 participants