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

XF 1.5 Duplicate primary key error when importing vB 3.8x in a new XF 1.54

Discussion in 'Installation, Upgrade, and Import Support' started by vFranky, Jan 3, 2016.

  1. vFranky

    vFranky Active Member


    I have tried to import a 500.000 postings vBulletin 3.8 forum to a new XenForo 1.54 installation. Everything works fine until around 80% of importing forums and post, the the following mysql server error was displayed, see below.

    Any ideas? Thank you in advance!

    Kind regards,


    Attached Files:

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    1) Make sure your vB database doesn't have two posts with postid 442946. This is normally not possible but check it anyways.

    2) Make sure your XF forum is a brand new installation and that no one is making posts during the import.

    Those are the two likely explanations for this error. Once you have addressed both of these things then you will need to reinstall XenForo fresh and run the import again.

    When you start an import it gives you an option to preserve the source ids. Enabling that option requires a brand new installation or you can get collisions like this.

Share This Page