MyBB Community Forums

Full Version: MyAwards Error [SQL]
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
When i enable the plugin i get 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' at line 10
Query:
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;
can you open the plugin file in a editor (eg. notepad++) and change TYPE=MyISAM; to ENGINE=MyISAM;
That seemed to work but i don't have the option to add an award in the User & Group area.

Anyone
Have you uploaded all the plugin files? I'm pretty sure one of the files needs to be uploaded to the /admin/modules/users folder.