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

Closed
anonymous-piwik-user opened this Issue Sep 11, 2013 · 1 comment

3 participants

@anonymous-piwik-user

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
Piwik Open Source Analytics member

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-piwik-user anonymous-piwik-user added this to the 2.0 - Piwik 2.0 milestone Jul 8, 2014
@sabl0r sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
@mattab mattab Fixes #4149 Quick fix by ignoring the URL that failed to insert. To p…
…roperly 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 )
2034818
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment