Impex error help needed!!!!

[lildevil07]

Hi,
I am trying to downgrade vb4 to vb3 using this guide

http://webcache.googleusercontent.com/search?q=cache:Y8gddqHFVvkJ:www.vbteam.info/4-x-x-tutorials/45483-downgrade-vb-4-0-x-to-3-8-x-without-losing-passwords.html+site:vbteam.info+how+to+downgrade+vbulletin+4&cd=6&hl=en&ct=clnk&source=www.google.com

but after clicking import i get this error......

ImpEx Database errormysql 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: Friday 03rd 2011f June 2011 07:43:31 AM
Database: vb3
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 am using the latest wamp server on my pc in order to test it...

Someone plz help me out...

Regards

lildevil07 Reviewed by lildevil07 on 3rd Jun 2011. Impex error help needed!!!! Hi, I am trying to downgrade vb4 to vb3 using this guide http://webcache.googleusercontent.com/search?q=cache:Y8gddqHFVvkJ:www.vbteam.info/4-x-x-tutorials/45483-downgrade-vb-4-0-x-to-3-8-x-without-losing-passwords.html+site:vbteam.info+how+to+downgrade+vbulletin+4&cd=6&hl=en&ct=clnk&source=www.google.com but after clicking import i get this error...... ImpEx Database errormysql error: Invalid SQL: CREATE TABLE impexerror ( errorid bigint(20) unsigned NOT NULL Rating: 5

[Lock Down]

Change the type=MyISAM to engine=MyISAM

[lildevil07]

Thanks for the help..

[Lock Down]

You are welcome.