1 May 2011, 6:04 PM
Administrator
- Join Date:
- Feb 2006
- Location:
- Tampa Bay, Florida
- Posts:
- 10,695
- Plugin Contributions:
- 56
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.