MyBB Community Forums

When trying to activate whodownloadattachment.php I get this
SQL Error:
1064 - 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 9
Query:
CREATE TABLE mybb_whodownloadattachment ( lid bigint(30) UNSIGNED NOT NULL auto_increment, aid bigint(30) UNSIGNED NOT NULL default '0', date bigint(30) UNSIGNED NOT NULL default '0', whodownloadit text NOT NULL default '', PRIMARY KEY (lid) ) TYPE=MyISAM

here's the file:
[attachment=27994]

I fixed the description like Vernier suggested in another thread but I guess that's not the issue here.
MyBB version 1.6.8 and it's a new install.
thank you.

Change;

TYPE=MyISAM

to;

ENGINE=MyISAM

That was exactly it! Thank you Yaldaram!

here's the file incase anyone wants it? it works now:
[attachment=27997]