Help Importing from UBB threads to Vbulletin 3.5.3

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • DeeperImage
    Senior Member
    • Nov 2001
    • 221

    Help Importing from UBB threads to Vbulletin 3.5.3

    Here is the problem I am having. All I have is the backed up files from the original UBB Threads Infopop board. I am trying to restore that file to a live DB but I get the following error.

    Code:
    [B]Error[/B]
    SQL-query :  
    
    [B][COLOR=#990099]CREATE[/COLOR][/B] [B][COLOR=#990099]TABLE[/COLOR][/B] [COLOR=#008000]`w3t_AddressBook`[/COLOR] [COLOR=#ff00ff]([/COLOR] [COLOR=#008000]`Add_Owner`[/COLOR] [COLOR=#ff9900]int[/COLOR][COLOR=#ff00ff]([/COLOR] [COLOR=#008080]9[/COLOR] [COLOR=#ff00ff])[/COLOR] [COLOR=#0000ff]unsigned[/COLOR] [B][COLOR=#990099]NOT[/COLOR][/B] [B][COLOR=#990099]NULL[/COLOR][/B] [COLOR=#0000ff]default[/COLOR] [COLOR=#008000]'0'[/COLOR][COLOR=#ff00ff],
    [/COLOR][COLOR=#008000]`Add_Member`[/COLOR] [COLOR=#ff9900]int[/COLOR][COLOR=#ff00ff]([/COLOR] [COLOR=#008080]9[/COLOR] [COLOR=#ff00ff])[/COLOR] [COLOR=#0000ff]unsigned[/COLOR] [COLOR=#0000ff]default[/COLOR] [B][COLOR=#990099]NULL[/COLOR][/B] [COLOR=#ff00ff],
    [/COLOR][B][COLOR=#990099]KEY[/COLOR][/B] [COLOR=#008000]`address_ndx1`[/COLOR] [COLOR=#ff00ff]([/COLOR] [COLOR=#008000]`Add_Owner`[/COLOR] [COLOR=#ff00ff])[/COLOR] 
    [COLOR=#ff00ff])[/COLOR]ENGINE [COLOR=#ff00ff]=[/COLOR] [COLOR=#0000ff]InnoDB[/COLOR] [COLOR=#0000ff]DEFAULT[/COLOR]CHARSET [COLOR=#ff00ff]=[/COLOR] latin1 
    
    MySQL said: 
    
    You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 5
    This happens when I try to restore that backup file into a live DB so that I can then use IMPEX to move it to VBULLETIN. What am I doing wrong? Help.
    Cobbcountyforums.com
  • Jerry
    Senior Member
    • Dec 2002
    • 9137
    • 1.1.x

    #2
    I would edit the source and remove "DEFAULTCHARSET = latin1" from all the CREATE TABLE statments.
    I wrote ImpEx.

    Blog | Me

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...