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

in piwik_log_action.name Russian characters are stored with the issues #2749

Closed
anonymous-matomo-user opened this issue Oct 31, 2011 · 4 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Milestone

Comments

@anonymous-matomo-user
Copy link

In piwik_log_action.name Russian characters are stored with the issues (question marks "??????"). Although, for example, in table piwik_log_action.referer_keyword stored without error...

Judging by the logs errors began in September (occasionally update from SVN)

@robocoder
Copy link
Contributor

We do not support direct access to the Piwik database. You must use Piwik's API.

In the case of referer_keyword, Piwik programmatically decodes the referer.

@robocoder
Copy link
Contributor

p.s. updating from svn is at your own risk. Make sure you may have this changeset: [5324]

@anonymous-matomo-user
Copy link
Author

Excuse me, if not described the problem. I'll try again. The error occurs in the derivation of page titles (or rather, at what stage is saved in the database until you can find a method that would show)
[http://stat.z-gu.ru/?module=API&method=Actions.getPageTitles&idSite=6&date=yesterday&period=day&format=html&filter_limit=10]

In backend looks so: [http://hostingkartinok.com/image/01201110/4274cf70cb2b2299d19b1b106ef758a6.png]

Although the module keywords - works fine:
[http://stat.z-gu.ru/?module=API&method=Referers.getKeywords&idSite=6&date=yesterday&period=day&format=html&filter_limit=10]

At least direct where to look. Thanks in advance.

p.s.: I'm using version 5398

@anonymous-matomo-user
Copy link
Author

hm... problem solved

possibly after removal all

default-character-set=*

(was default-character-set=utf8)

from /etc/mysql/my.cnf

and reboot server

@anonymous-matomo-user anonymous-matomo-user added this to the 1.7 Piwik 1.7 milestone Jul 8, 2014
This issue was closed.
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. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

3 participants