Database error in vBulletin 3.5.2:
Invalid SQL:
CREATE TABLE `inferno_attack` (
`aid` int(11) NOT NULL auto_increment,
`aname` text NOT NULL,
`atype` text NOT NULL,
`asprite` text NOT NULL,
`amp_cost` int(15) NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM;;
MySQL Error : You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 8
Error Number : 1064
Date : Sunday, January 1st 2006 @ 05:34:18 PM
Script :
http://localhost/forums/admincp/rpgi...stallation.php
Referrer :
http://localhost/forums/admincp/rpgi...stallation.php
IP Address : 127.0.0.1
Username : Viral Architect
Classname : vb_database
My best guess is that my SQL database doesn't like MyISAM. Can I replace this with anything? What can I replace it with?
EDIT: To fix this problem, replace ENGINE=MyISAM to TYPE=MyISAM