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

 

[Lock Down]

Change the type=MyISAM to engine=MyISAM

 

[lildevil07]

Thanks for the help..

 

[Lock Down]

You are welcome.