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

A fatal error occurred - The string to escape is not a valid UTF-8 string #14485

Closed
MERamadan opened this issue May 26, 2019 · 1 comment · Fixed by #15618
Closed

A fatal error occurred - The string to escape is not a valid UTF-8 string #14485

MERamadan opened this issue May 26, 2019 · 1 comment · Fixed by #15618
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc. Help wanted Beginner friendly issues or issues where we'd highly appreciate community's help and involvement.
Milestone

Comments

@MERamadan
Copy link

MERamadan commented May 26, 2019

We are facing the below issues as we our url's have Arabic characters. This happens when track download files and file names are in Arabic.

Firstly we get a bad request response when we track the file download, then we applied the utf8mb4 setting on mysql as suggested at issue #11136, after that we got a OK response from matomo.

However, when we open the dashboard or visitors log we are getting error "Oops… there was a problem during the request.....".

Errors:
(1) The string to escape is not a valid UTF-8 string.
in D:\Matomo\matomo\plugins\Live\templates\getLastVisitsStart.twig line 73

(2) The string to escape is not a valid UTF-8 string.
in D:\Matomo\matomo\plugins\CoreHome\templates_dataTable.twig line 67

Screenshot:
matomo-1

Environment Information:
Matomo v3.9.1
MySQL 8.0.15 (Community - Win64)
IIS 10
Windows Server 2019 (1809)

MySQL Configurations
mysql-1

Tracking Url's to try to reproduce the issue
http://10.10.158.242:6660/piwik.php?idsite=1&rec=1&apiv=1&r=946539&uid=fa%40ecas.com&_idts=1558851102&_idvc=0&_id=909de6088a99b7d5&url=http%3a%2f%2f10.10.158.242%3a4040%2fECASLibrary002%2f%d8%b3%d8%ac%d9%84+%d8%b9%d9%85%d9%84+2019_DMA_00006+(1)%2f%d9%86%d9%85%d9%88%d8%b0%d8%ac+%d8%b9%d8%b1%d8%b6+%d8%a7%d9%84%d8%ac%d9%87%d8%a9.pptx&urlref=http%3a%2f%2f10.10.158.242%3a4040%2findex.aspx&dimension1=8e7449cd-ba1c-e611-80d2-0050568e7fa1&dimension2=External&dimension3=1cfc40ed-7b7f-e911-89cb-005056bb5a0e&dimension4=ec_workitem&download=http%3a%2f%2f10.10.158.242%3a4040%2fECASLibrary002%2f%d8%b3%d8%ac%d9%84+%d8%b9%d9%85%d9%84+2019_DMA_00006+(1)%2f%d9%86%d9%85%d9%88%d8%b0%d8%ac+%d8%b9%d8%b1%d8%b6+%d8%a7%d9%84%d8%ac%d9%87%d8%a9.pptx

http://10.10.158.242:6660/piwik.php?idsite=1&rec=1&apiv=1&r=574682&uid=fa%40ecas.com&_idts=1558851106&_idvc=0&_id=909de6088a99b7d5&url=http%3a%2f%2f10.10.158.242%3a4040%2fECASLibrary002%2f%d8%b3%d8%ac%d9%84+%d8%b9%d9%85%d9%84+2019_DMA_00006+(1)%2f%d8%af%d8%b1%d8%a7%d8%b3%d8%a9+%d8%a7%d9%84%d9%82%d8%b7%d8%a7%d8%b9+-+2017_00020-+SectorAnalysis.docx&urlref=http%3a%2f%2f10.10.158.242%3a4040%2findex.aspx&dimension1=8e7449cd-ba1c-e611-80d2-0050568e7fa1&dimension2=External&dimension3=1cfc40ed-7b7f-e911-89cb-005056bb5a0e&dimension4=ec_workitem&download=http%3a%2f%2f10.10.158.242%3a4040%2fECASLibrary002%2f%d8%b3%d8%ac%d9%84+%d8%b9%d9%85%d9%84+2019_DMA_00006+(1)%2f%d8%af%d8%b1%d8%a7%d8%b3%d8%a9+%d8%a7%d9%84%d9%82%d8%b7%d8%a7%d8%b9+-+2017_00020-+SectorAnalysis.docx

http://10.10.158.242:6660/piwik.php?idsite=1&rec=1&apiv=1&r=075426&uid=fa%40ecas.com&_idts=1558851118&_idvc=0&_id=909de6088a99b7d5&url=http%3a%2f%2f10.10.158.242%3a4040%2fECASLibrary002%2f%d8%b3%d8%ac%d9%84+%d8%b9%d9%85%d9%84+2019_DMA_00006+(1)%2f%d9%86%d9%85%d9%88%d8%b0%d8%ac+%d8%a7%d9%84%d8%b9%d8%b1%d8%b6+%d8%a7%d9%84%d8%aa%d9%82%d8%af%d9%8a%d9%85%d9%8a+%d9%84%d9%84%d9%85%d8%ac%d9%84%d8%b3+%d8%a7%d9%84%d8%aa%d9%86%d9%81%d9%8a%d8%b0%d9%8a.pptx&urlref=http%3a%2f%2f10.10.158.242%3a4040%2findex.aspx&dimension1=8e7449cd-ba1c-e611-80d2-0050568e7fa1&dimension2=External&dimension3=1cfc40ed-7b7f-e911-89cb-005056bb5a0e&dimension4=ec_workitem&download=http%3a%2f%2f10.10.158.242%3a4040%2fECASLibrary002%2f%d8%b3%d8%ac%d9%84+%d8%b9%d9%85%d9%84+2019_DMA_00006+(1)%2f%d9%86%d9%85%d9%88%d8%b0%d8%ac+%d8%a7%d9%84%d8%b9%d8%b1%d8%b6+%d8%a7%d9%84%d8%aa%d9%82%d8%af%d9%8a%d9%85%d9%8a+%d9%84%d9%84%d9%85%d8%ac%d9%84%d8%b3+%d8%a7%d9%84%d8%aa%d9%86%d9%81%d9%8a%d8%b0%d9%8a.pptx

@tsteur tsteur added Bug For errors / faults / flaws / inconsistencies etc. Help wanted Beginner friendly issues or issues where we'd highly appreciate community's help and involvement. labels May 28, 2019
@tsteur
Copy link
Member

tsteur commented May 28, 2019

refs #9785 and #11136

can you confirm all Matomo tables have UTF8MB4?

@mattab mattab added this to the 4.0.0 milestone Jan 21, 2020
@sgiehl sgiehl linked a pull request Mar 2, 2020 that will close this issue
@sgiehl sgiehl self-assigned this May 11, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Help wanted Beginner friendly issues or issues where we'd highly appreciate community's help and involvement.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants