Fixed Import fails on thread prefixes

[Rigel Kentaurus]

I got the following error while importing my vBulletin forum (3.8), at the Thread Prefixes stage




While checking the database, it seems that I had some thread prefixes that are associated to no forum (most likely the forum was deleted from the "forum" table but not the "forumprefixset")

That seems to halt the import process in a really ungraceful way.

 

[Jake Bunce]

Here is a query to prune those orphaned records from the vB database:

DELETE fps.* FROM forumprefixset AS fps
LEFT JOIN forum AS f ON (f.forumid = fps.forumid)
WHERE f.forumid IS NULL;

 

[Mike]

Fixed - just not inserting anything if the map look up fails.