• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Michele Neylon :: Pensieri

Michele Neylon :: Pensieri

Technology, Marketing, Domains, Thoughts

Using Vbulletin’s Impex Import System With Newer Versions of MySQL

September 26, 2013 by Michele Neylon 4 Comments

vbulletin-logo-2013If you are moving a forum to Vbulletin or, like me, need to move an existing Vbulletin install around, then you might end up using Vbulletin’s “impex”.

Impex is an import system that allows you to import users, posts etc., from a very large number of bulletin board and forum software into Vbulletin.

To save your sanity – remove the CMS / Forum software importers that you won’t be using from:

/impex/systems

I was using Vbulletin to Vbulletin so I nuked all the others – if you don’t you’ll end up with a confusing mess

For some bizarre reason the code in the index.php makes reference to some SQL that will not work with MySQL 5.*

So you’ll get a rather unhelpful error message like this:

 

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE impexerror (
errorid bigint(20) unsigned NOT NULL auto_increment,
errortype varchar(10) NOT NULL default ”,
classnumber varchar(3) NOT NULL default ”,
importid bigint(20) NOT NULL default 0,
error varchar(250) default ‘NULL’,
remedy varchar(250) default ‘NULL’,
PRIMARY KEY (errorid)
) TYPE=MyISAM

mysql error: 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 ‘TYPE=MyISAM’ at line 9

mysql error number: 1064

So you need to open up your index.php and make one minor edit.

Around line 270 you should see:

 $error_table = “CREATE TABLE {$impexconfig[‘target’][‘tableprefix’]}impexerror (
errorid bigint(20) unsigned NOT NULL auto_increment,
errortype varchar(10) NOT NULL default ”,
classnumber varchar(3) NOT NULL default ”,
importid bigint(20) NOT NULL default 0,
error varchar(250) default ‘NULL’,
remedy varchar(250) default ‘NULL’,
PRIMARY KEY (errorid)
) TYPE=MyISAM”;

The last bit of that uses “TYPE” which is no longer valid. You need to switch it to “ENGINE”

So you should end up with:

 $error_table = “CREATE TABLE {$impexconfig[‘target’][‘tableprefix’]}impexerror (
                                                errorid bigint(20) unsigned NOT NULL auto_increment,
                                                errortype varchar(10) NOT NULL default ”,
                                                classnumber varchar(3) NOT NULL default ”,
                                                importid bigint(20) NOT NULL default 0,
                                                error varchar(250) default ‘NULL’,
                                                remedy varchar(250) default ‘NULL’,
                                                PRIMARY KEY (errorid)
                                        ) ENGINE=MyISAM”;

 

You’ll now be able to run impex 🙂

 

Related Posts:

  • distance-traveled
    The Irish Postal Service Failed Me!
  • 292580518_118073084270186_721063704789268417_n
    Keeping the Greenhouse Under Control is an Uphill Struggle!
  • ACDC-Dublin-Ticketmaster-Q
    The "Joys" of Acquiring Concert Tickets
  • fabric-swatch
    I Finally Bought a New Couch!
  • 311770507_1104098780309552_4889106500802127767_n
    Planning 2023's Planting
  • computer-code-screens
    Dodgy WordPress Developer Tactics

Filed Under: Techie :: Techno :: Tagged With: mysql, vbulletin

Michele is founder and CEO of Irish hosting provider and domain name registrar Blacknight. Read More…

Reader Interactions

Comments

  1. Gary M. says

    June 2, 2014 at 4:48 pm

    Outstanding! This was the solution T0 my import woes. Thanks !

  2. Tallon says

    August 12, 2014 at 10:30 pm

    Thank you so much! F**k!!! Saved me such a headache

  3. Matt says

    October 7, 2014 at 7:22 pm

    F**K IMPEX. It’s a horrible piece of garbage.
    Thanks for making it suck just a slight bit less.

  4. Matthew says

    November 16, 2014 at 1:26 pm

    Brilliant, thank you – works a treat! 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

dotblog founder

Mastodon

Archives

  • Bluesky
  • Instagram
  • Threads
  • Twitter

Pages

  • About Me
  • About This Site
  • Archives
  • Comments Policy
  • Contact Me
  • Newsletter
  • Privacy

Blogroll

  • Tom Doyle
  • Blacknight Blog
  • My Mastodon
  • Grandad
  • Damien Mulley

Stalking Links

Subscribe to Michele Neylon :: Pensieri

Blogroll

  • Blacknight Blog
  • Damien Mulley
  • Gianni Ponzi
  • Gordon Hudson
  • Grandad
  • My Mastodon
  • Paul Savage – BlackDog SEO
  • Stewart Curry
  • Technology.ie Podcast
  • Tom Doyle

Sites

  • Business Travel Tips
  • Discount Coupon Codes
  • Domain News
  • Fat.ie – my diet blog
  • Film Posters
  • Film Reviews
  • Films
  • Free Desktop Wallpapers
  • Irish Blogger Discussion Forum
  • Irish Stamps
  • Movie Trailers and News
  • Paste.ie

Footer

Site hosted in Ireland by Blacknight - Content copyright Michele Neylon

Copyright © 2025 · Magazine Pro on Genesis Framework · WordPress · Log in