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

XF 1.5 vb4 import problems

Discussion in 'Installation, Upgrade, and Import Support' started by Nano2nd, Oct 10, 2016.

  1. Nano2nd

    Nano2nd Member

    Hi all, i'm just starting up my migration to Xenforo project, i'm trying to run the importer but its failing on the threads import:

    Mysqli statement execute error : Duplicate entry '1458324' for key 'PRIMARY'

    any ideas? i didn't have this issue when i tried it last time, i've used both the web and cli importers and its the same

  2. Slavik

    Slavik XenForo Moderator Staff Member

    Check your source database for a duplicate post ID of 1458324

    If everything looks fine there, most likely an error with php on the import step, check the XenForo post table and remove post ID 1458324 and it should let you continue (as they are imported in batches, you may have to remove a handful of ID's higher than that one also to allow it to re-import them and continue)
  3. Nano2nd

    Nano2nd Member

    Hi Slavik, checked that and theres no duplicates in th post table, i'll continue see what happens
  4. Nano2nd

    Nano2nd Member

    okay so i now get:

    Mysqli statement execute error : Duplicate entry '2207220' for key 'PRIMARY'

    there no duplicate, if i delete it from the xen database (which appears to be a valid post i'm deleting) it won't let me continue this time :(

    this might be a daft question, but how do i "remove a handful of ID's higher" - if i sort the new post table by ID the newest entry is 7463673 ???
  5. Slavik

    Slavik XenForo Moderator Staff Member

    You should be looking as to why you are getting the duplicate entries (do you have other staff who may be triggering the import page for example, so 2 people are essentially trying to import the same data and will throw that error).

    The fix is the same, however, check the source database, and if required remove the duplicate from the XenForo database and try to allow it to continue.

Share This Page