I'm upgrading from ubb 6.5 and so I'm having to do the initial install and then migrate my data. When the installer is running through creating the tables I initially got the error:

SQL 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'

Which from what I read I just needed to change that to 'ENGINE=MyISAM', which I did and now I don't get that error. Instead, I'm getting the error:

SQL 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=heap'

I'm wondering if I just need this changed to 'ENGINE=heap' too or is this something completely different?

The answer I got a while ago is the installer/upgrade script is the problem with that version.
http://www.ubbcentral.com/forums/ubbthreads.php/ubb/showflat/Number/241410/

Maybe Rick has a handy dandy fix for it.

Here's what the manual has to say...

http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html

I was able to change to TYPE=memory and that allowed the script to run all the way through once I removed all the tables from the database.

Thanks for your reply :-)

FYI: I had the same problem and changing TYPE=MyISAM to TYPE=memory did not work.

My hosting service has MySQL ver5.5.21 and I had to change
TYPE=MyISAM to ENGINE=MyISAM
and
TYPE=heap to ENGINE=memory
then all worked great.

You should consider upgrading your scripts for the newer versions of PHP. Or give us options to choose for the PHP version.