mysql error number: 1064

[justasiam]

I have new installation of vB 4.2.3 and just installed impex so I can import from my old vB 4.0.2 (I think that is the version). Anyway, I configued the ImpExConfig.php to have the database info for the source and target and double-checked the info.
When I click on the "import" link in my ACP, and put in my customer number, I get the following error:

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

Date: Thursday 21st 2016f April 2016 10:41:42 PM
Database: HidingPlaceForums
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

I know that the1064 erro means that it did not understand the command sent to it.

Ideas?

[Dave]

Open up the file where the error is occurring and remove all occurrences of "TYPE=MyISAM".

[justasiam]

That is in the original unmodified vB 4.23. is this what you mean?

[Dave]

Well the error is related to creating tables for Impex so I assume you have to modify one of the Impex files where it attempts to create the required table structure.

[squidsk]

Wait why are using impex to upgrade an old version of vb to a new one instead of just running the built in upgrade scripts.

[justasiam]

Dave, that solved the problem, thank you.

Squidsk, I was trying to a fresh new forum, then decided that I still needed some of the posts from the old one and decided that importing is the better solution.

[TheLastSuperman]

Originally Posted by squidsk

Wait why are using impex to upgrade an old version of vb to a new one instead of just running the built in upgrade scripts.

Great question!

Originally Posted by justasiam

Dave, that solved the problem, thank you.

Squidsk, I was trying to a fresh new forum, then decided that I still needed some of the posts from the old one and decided that importing is the better solution.

Back when vB4 first came out and many didn't read the upgrade documentation... they bombed their sites, literally... it was a fiasco back then! Long story short the reason why squid ask that is because all of us know you should only use impex to import posts from one vBulletin to another as a last resort. What you should have done and anyone reading this in the future should do is to simply upgrade the site instead of importing. Once done upgrading simply delete what you don't need and then you're set. Using impex in such a way as you've done will yield results yes, however there's a number of factors involved that could potentially cause issues immediately or later down the road.

Upgrading then deleting what you don't need is a much better alternative.