[Forum] 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:

[INDENT]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[/INDENT]

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

Ideas?

[Trevor Hannant]

Why are you importing rather than upgrading? Impex was designed to either:

- move from another forum system to vBulletin or
- merge two vBulletin installations together

It's not supported for any other reason.

[Paul M]

The error means you dont have the engine type MyISAM enabled on your MySQL server.