Fixed Import fails on thread prefixes

Rigel Kentaurus

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

Screen Shot 2011-11-23 at 3.15.59 AM.png

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

XenForo moderator
Staff member
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;