UBB.threads PHP Forum Software Community Forums UBB.threads 7 Installation and Upgrade Support Upgrade problem using mysql 5.5

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.
https://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.