Invalid, skipping. Failed on : threadid (3.7.3->3.7.3)

[stangfan.com]

3.7.3 (500K+ posts / was closed board) importing into 3.7.3 (200+ posts live board)

same webserver and db server



87.50 % Post ->
Invalid, skipping. Failed on : threadid
Invalid, skipping. Failed on : threadid
Invalid, skipping. Failed on : threadid
Invalid, skipping. Failed on : threadid
87.50 % Post ->
87.50 % Post ->
Invalid, skipping. Failed on : threadid
87.50 % Post ->
87.50 % Post ->
87.50 % Post ->
Invalid, skipping. Failed on : threadid
87.50 % Post ->
87.50 % Post ->
87.50 % Post ->
87.50 % Post ->
Invalid, skipping. Failed on : threadid
Invalid, skipping. Failed on : threadidCan anyone explain the cause of this error?
I have yet to complete the migration as the db being imported is large

[Jerry]

You're importing into a live board ?

The error means that the in comming post dosen't not have a thread to associate too.

[stangfan.com]

You're importing into a live board ?

By live meaning the current live db but its closed on a dev box.



The error means that the in comming post dosen't not have a thread to associate too.

Is this something i should be overly concerned about.

After import 0.1% of the import had "Invalid, skipping. Failed on : threadid"

Is there a pre merger solution?

[Jerry]

Has the board already had an import ? If there is a previous one you'll need to close the import.

Merge imports are typically the same as any other, just that with vB to vB more things have to be checked.

For test reasons you could try setting this in the ImpExConfig.php :



define('dupe_checking', false);

[stangfan.com]

Has the board already had an import ? If there is a previous one you'll need to close the import.

Merge imports are typically the same as any other, just that with vB to vB more things have to be checked.

For test reasons you could try setting this in the ImpExConfig.php :



define('dupe_checking', false);


Hi Jerry

To my understanding they closed one vB board and started another as their host could not support the upgrade, it lacked the resources. I have upgraded both to the same vBulletin package, 3.7.3.

So, to my knowledge there has been no previous imports into the database I am merging in to.

Will there be any change as well with doing


$impexconfig['system']['pagespeed'] = 5;

[Jerry]

The page speed is how long it waits before refreshing the page to load the next lot to import. It's designed to give the database time to recover or to allow for a laggy network connection to catch up.

The other common cause of "Invalid, skipping. Failed on : threadid" is that the posts are orphaned, and their target thread wasn't imported at all.

[stangfan.com]

The page speed is how long it waits before refreshing the page to load the next lot to import. It's designed to give the database time to recover or to allow for a laggy network connection to catch up.

The other common cause of "Invalid, skipping. Failed on : threadid" is that the posts are orphaned, and their target thread wasn't imported at all.

would you suggest that on both the old db and the new db i run the update counters for:
Remove Orphan Threads
Remove Orphan Posts

?

Then do the migration?

[Jerry]

On the source yes, for sure.

ImpEx dosen't touch any data on the target, though between import test you should revert the target to a pre import state to ensure there is no residual import data.

[stangfan.com]

On the source yes, for sure.

ImpEx dosen't touch any data on the target, though between import test you should revert the target to a pre import state to ensure there is no residual import data.

Perfect, I will run the orphan counters.

As for the target DB, I will be dropping it and reloading a fresh copy.

I will follow up :)

[stangfan.com]

After your suggestion and a brutally long import session, all went well.

Rather than 100k dropped posts, there was 16 :)

Thanks for responding to my question.

[Jerry]

This will help with that :

http://www.vbulletin.com/docs/html/med_large_import