MyBB Community Forums

Anyway to fix this??

Connection to the database server and table you specified was successful.

Database Engine: MySQL 5.5.8

The MyBB database tables will now be created.

Creating table forums1adminlog...
MyBB SQL 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 forums1adminlog ( 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;

Sincerely
Abandon.

This is a known issue. MyBB is incompatible with MySQL 5.5 for now. http://dev.mybb.com/issues/1379

This will be fixed in MyBB 1.6.3. For now, either downgrade you MySQL version or apply the patched files from that revision.

Nvm it worked.

Problem Solved.

Just replace in install/resources/mysql_db_tables.php:

TYPE=MyISAM;

with: (all instances)

ENGINE=MyISAM;