1. 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

Discussion in 'Resolved Bug Reports' started by ge66, Oct 7, 2013.

  1. ge66

    ge66 Active Member

    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.
     
  2. Mike

    Mike XenForo Developer Staff Member

    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.
     
  3. ge66

    ge66 Active Member

    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.
     
  4. Mike

    Mike XenForo Developer Staff Member

    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.)
     

Share This Page