When installing Addons ...

If you're getting errors like this when running the SQL for a mod:

ERROR 1064 (42000): 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 1

What you need to do to fix it is edit the .sql file and change

TYPE=MyISAM;

to

ENGINE=MyISAM;

Newer versions of MySQL have deprecated the use of "TYPE=" parameters in favor of "ENGINE=".

You could alternatively just remove it altogether, since in the majority of cases MyISAM will be the default anyway.


http://bugs.mysql.com/bug.php?id=17501