MyBB Community Forums

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 MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 10Query:CREATE TABLE mybb_myawards ( awid smallint(4) NOT NULL auto_increment, awname varchar(64) NOT NULL, awimg varchar(64) NOT NULL, awtype smallint(1) NOT NULL, awdescr varchar(255) NOT NULL, awpollid int(8) NOT NULL, awexptime bigint(30), PRIMARY KEY (awid) ) TYPE=MyISAM;

I get this error when i try to activate it 

please help...

have a great day!

I think you have the old version of MyAwards. The query in the latest version is as follows:

  if(!$db->table_exists("myawards"))
 {
 $db->query("CREATE TABLE ".TABLE_PREFIX."myawards (
 awid smallint(4) NOT NULL auto_increment,
    awname varchar(64) NOT NULL,
    awimg varchar(64) NOT NULL,
 awdescr varchar(255) NOT NULL,
 PRIMARY KEY  (awid)
 ) ENGINE=innodb;");

Recognize the ENGINE=innodb;. Your one uses TYPE which was removed in MySQL 5.5. The latest version of the plugin is 2.4. Get that version and you won't have this problem.

Ok thank you <3