[Resolved] Importer finished but only 60% of the total posts has been imported

I have successfully imported from UBB to VB 3.8 but have a problem with the import of all posts in XF.

Although the importer concludes successfully (with no errors, thx to Mike @post), the total number of Posts in the forum is sth like 60% of my total posts.

Total posts in VB (and in my previous forum UBB) is: 982,724 vs. 537,928 imported in XF


VB stats:
Code:
Threads: 24,897, Posts: [B]982,724[/B], Members: 7,597, Active Members: 1

SELECT count( * )
FROM `vb_post`
982,724
XF
Code:
Forum Statistics
 Discussions:
     24,081
 Messages:
     [B]537,928[/B]
 Members:
     7,590

SELECT count( * )
FROM `xf_post` 
count(*)
537928
I tried importing more than once, with the same result.
 

Mike

XenForo developer
Staff member
I'd have to have the data and ideally examples of stuff that wasn't imported. My only guess was that you actually had a lot of orphaned data (eg, posts in threads that don't exist, or threads in forums that don't exist).
 
F

Floris

Guest
Curious to hear as to the cause so it's a resource for future occurrences.
 
Top