Error in table create: 'TYPE=MyISAM' (SOLVED)
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