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

XF 1.1 Duplicate Entry Error on Import

Discussion in 'Installation, Upgrade, and Import Support' started by Static-Xbox, Mar 13, 2013.

  1. Static-Xbox

    Static-Xbox Active Member


    I'm in the process of importing vB data into a fresh xF install; however, while trying to import users I'm getting the following error (it is set to overwrite the admin account with my own account from the vB install, both of which have the same name and password, but no other accounts exist on the xF install at this time):

    I have already imported this same data into a test board without incident, so I am not sure what the problem is this time around. I should probably note that this installation is occurring in the same location as where the vB install used to be (database is in-tact, files are not), if that has any bearing on the error.

    Any help in getting this sorted would be greatly appreciated!

    EDIT -- New information, it seems that after checking, two spam bots got through registration before I managed to turn it off (amazing feat, considering I literally did that seconds after finishing the install...), which I am assuming means importing valid user ids 2-3 won't be possible. Is there a way to purge these two entries from the DB without having to start over with a fresh install?
  2. Static-Xbox

    Static-Xbox Active Member

    Another piece of new information -- it turns out that somehow one of the bots managed to register before the admin account was created, giving it the userid 1, and making my userid 2. This seems to be causing a conflict with the user import. Is there a way to fix this, so that my userid reverts to 1?
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Are you able to restart the import?

    That would be my suggestion - obviously disabling registrations first this time.
  4. Static-Xbox

    Static-Xbox Active Member

    I wound up deleting the new xf database and restarting, which worked. Thanks Brogan!

    My only question remaining is how a user wound up being able to register while I was still in the install script setting up the Administrator account...
  5. Brogan

    Brogan XenForo Moderator Staff Member

    I haven't actually tested it but it's possible that registrations are possible before the administrator account is created.

    I will need to check on a localhost install.

Share This Page