1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Fixed Import fails on thread prefixes

Discussion in 'Resolved Bug Reports' started by Rigel Kentaurus, Nov 23, 2011.

  1. Rigel Kentaurus

    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.
     
    Mike likes this.
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

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

    Code:
    DELETE fps.* FROM forumprefixset AS fps
    LEFT JOIN forum AS f ON (f.forumid = fps.forumid)
    WHERE f.forumid IS NULL;
    
     
    Rigel Kentaurus likes this.
  3. Mike

    Mike XenForo Developer Staff Member

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

Share This Page