MyBB Community Forums

Hell Mybb Support Team I am new installer of Mybb on my Host I was installing a SPider bots Plugin and various other plugins too got 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;

Plugin link :http://mods.mybb.com/view/spider-bots

Error Image:

http://i.imgur.com/g13ae.png


Some one Help me it is a free plugin i didnt not use any pirated Plugin GUys help me this is my first installation of mybb

Thank you

Mr respect

Open the plugin file using an editor such as notepad++ and replace line 36 with the following:

			) ENGINE=MyISAM");

Alternatively, use this modified version:

(2012-04-24, 04:31 PM)euantor Wrote: [ -> ]Open the plugin file using an editor such as notepad++ and replace line 36 with the following:

			) ENGINE=MyISAM");

Alternatively, use this modified version:

Oh yeah you rock dude it worked at last it is common for all plugins now i found out thanks a lot dude Best support from mybb