MyBB Community Forums

when i try to install it gives me this error:
MyBB has experienced an internal SQL error and cannot continue.

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 CHARACTER SET utf8 COLLATE utf8_general_ci' at line 9
Query:
CREATE TABLE mybb_adminlog ( uid int unsigned NOT NULL default '0', ipaddress varchar(50) NOT NULL default '', dateline bigint(30) NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

i am runing xp with wamp2 as server
i have done all i know to try to fix it.
what am i doing wrong?

This is due to a change in MySQL 5.5. Either downgrade to <5.5 or wait for the next mybb release which will have this solved.

You can read this recent thread for more info:
http://community.mybb.com/thread-85251.html

Or, if you really wanted to, you could go through all the SQL Queries and changed TYPE to ENGINE.

- G33K -'s way is better