• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

As designed Import user from vb3.8 problem

ge66

Active member
#1
When importing I get:

The following users conflicted with existing users' names or email addresses. Please resolve these conflicts.
User: Gorel (emailremoved)
Inlägg: 21, Blev medlem: 4 Mar 2009
Merge with existing user
Change conflicting user name:


User: Trotter (emailremoved)
Inlägg: 1, Blev medlem: 8 Jul 2012
Merge with existing user
Change conflicting user name:


User: apple (emailremoved)
Inlägg: 4, Blev medlem: 30 Jul 2012
Merge with existing user
Change conflicting user name:

This is just some examples, they are supposed to have conflicting usernames. The conlicting usernames are:
Görel and Gorel
Trötter and Trotter
Äpple and apple

I then change the conlicting usernames to
Gorel2xen
Trotter2xen
apple2xen

When I search for apple in the forum I see apple2xen and Äpple.

If the importer had to change Äpple to Apple I could understand why I would have to change apple to something else.

I think its a bug that it cant see the difference between Äpple and Apple and still import Äpple.
 

Mike

XenForo developer
Staff member
#2
MySQL is "accent insensitive". In its eyes, Äpple == Apple. As such, XenForo follows this. I don't know of any way to change this in MySQL.
 

ge66

Active member
#3
Ok, thank you, is there a way to not merge and not change usernames when importing, just leave them, as they seem to be different after import or will that mean trouble later.
 

Mike

XenForo developer
Staff member
#4
No, they can't both be inserted into the database. MySQL will error. (And this behavior is actually often useful as it means that people don't necessarily have to be perfect with accents when searching for users, tagging them, etc.)