MyBB Community Forums

I want to install the plugin shoutbox (2.2.0) but get the error "MyBB SQL Error 1064"

What do I do? 


Error message:
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 8

Query:
CREATE TABLE mybb_shouts ( sid int(10) unsigned NOT NULL auto_increment, uid int(10) unsigned NOT NULL default '0', message text NOT NULL, dateline bigint(30) NOT NULL default '0', ipaddress varchar(30) NOT NULL default '', PRIMARY KEY (sid) ) TYPE=MyISAM

exactly which version of MyBB you are using and give the shoutbox link you are trying to use ..

edit: if you are using MyBB 1.6.x then there are better shoutbox plugins
MyShoutbox | inferno shoutbox | DVZ Shoutbox

That plugin is definitely old because using Type=whatever engine is certainly depreciated and has been for quite a while. It could work by changing Type=MyISAM to Engine=MyISAM, but I'd suggest a plugin that has been more recently updated.

i have a version of inferno that works with 1.8.4 if you want the files feel free to contact me via skype or email
(mikeorman or [email protected])