MyBB Community Forums

I was going to install mybb in localhost with XAMPP but when i start the installation on Table Creation i get this :

Table Creation

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 mybb_adminlog...
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 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;

Please contact the MyBB Group for support.

Please help..

This could be due to an old version of mySQL. Which version have you got installed? I've never had this problem when I used XAMPP.

The 1.6 series is not compatible with MySQL 5.5 just yet - the next maintenance release will be though.

You can go through ./install/resources/mysql_db_tables.php and change all instances of TYPE=MyISAM to ENGINE=MYISAM and it will work after that.

Thanks !!!!!