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

Bug: When adding urls to a site the german umlauts are not handled correctly #4149

Closed
anonymous-matomo-user opened this issue Sep 11, 2013 · 1 comment
Assignees
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@anonymous-matomo-user
Copy link

When adding an url with a german umlaut to a site where is the same url but without umlaut, there will show up a sql-error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-http://heretheurl' for key 'PRIMARY'

Example:
Try to add "examplemlaut.org"
Then try to add "exampleumlaut.org"
Both handled as same name!

@mattab
Copy link
Member

mattab commented Oct 14, 2013

In 2034818: Fixes #4149 Quick fix by ignoring the URL that failed to insert. To properly fix one can change the collatoin on the site_url table to use German collation in mysql 5.5 (maybe other collations would work too see mysql bug http://bugs.mysql.com/bug.php?id=57860 )

@anonymous-matomo-user anonymous-matomo-user added this to the 2.0 - Piwik 2.0 milestone Jul 8, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
…sert. To properly fix one can change the collatoin on the site_url table to use German collation in mysql 5.5 (maybe other collations would work too see mysql bug http://bugs.mysql.com/bug.php?id=57860 )
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. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

No branches or pull requests

3 participants