Symphony.

Hello everyone,

MySQL 5.5.6 rc was recently released, as part of that release the following syntax has been deprecated:

CREATE TABLE `table_name` (
    ...
) TYPE=MyISAM;

Instead of using TYPE= the correct syntax is ENGINE=.

Further, MyISAM is no longer the default table engine, InnoDB is, so when creating tables you need to make sure you specify an engine every time, or you could be in for some unexpected behaviour.

So, hopefully this change won’t catch you unaware as it did for us.

Just to clarify, 5.5 hasn’t been released yet, but it’s now in Release Candidate.

MySQL 5.5 uses InnoDB by default, and they actually recommend it over MyISAM regardless of if you are using Foreign Keys, Transactions, or just generally want a more ACID solution, so it is something to consider for future extensions.

I’ve made this commit, that will fix this issue for Symphony 2.1.2 and it will attempt to correct any queries made by extensions that still use the old TYPE= syntax.

Just more fuel on the fire for database agnosticism in a future release :) Installing 5.5rc now to see if there are any major issues with my extensions…

Thanks, Rowan (a.k.a. buzzomatic). I have updated my extensions.

Great :) Now if only someone would update mine :(