Missing Threads/Post

[tamsin]

I'm importing from phpbb2.19 to vB 3.6. Impex seems to be not finishing of the import of threads/posts.

Impex reports posts: 581926 successful; 10 failures

My total posts listed on the original board are 641800, vb board is showing 637901. I checked the two databases and the counts match the respective number of rows in thhe databases.

The highest importpostid in the target db is 583235, the source db goes up to a post_id of 643215.

So approx 4000 of the most recent posts aren't being transfered.

I have a similar problem for topics/threads.

Impex report: 45746
orginal board: 45926
vb board: 45746

180 topics/threads missing

Thanks,
Tamsin

[tamsin]

I've been having a closer look and I noticed the test I ran a few days before stopped at exactly the same count in impex.

That test was done on a backup of the live database. The latest try, I turned the main forum off and used the live database as a source which now has 2-3 days new data.

Could it be something wrong with row 581926? It looks like a normal post to me.

Tam

[Jerry]

Indeed, there could be some content in that post that could be breaking the html-2-bb parser.

Though if the module completes then its not breaking.

ignore the id's in the database they will be misleading, go from the ImpEx count or look at the database directly to see the table total.

[tamsin]

I tracked down the problem. I think when we had a hiccup with the database a few months back it ended up with about 1000 records in the post table that didn't have a corrisponding record in the post_text table. Impex seems to have stopped the import after it reached these posts and for some reason the 50,000 odd posts after that point were not added or listed as failed.

I went through the database and deleted the the entries in the post table that didn't have post_text entries and reran the import.

The import posts stats jumped from 581926 to 634208.

Tam

[Jerry]

Ahhh there we go, all good now ? :)

[tamsin]

Yes thanks :) I'm just doing the live import now :D