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?