XF 1.5 vb4 import problems

[Nano2nd]

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

thx!

 

[Slavik]

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)

 

[Nano2nd]

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

 

[Nano2nd]

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 ???

 

[Slavik]

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.