MyBB Community Forums

Hi
when I try to active "important messages" plugin, I get this message:

MySQL error: 1050
Table 'mybb_importantmsgs' already exists
Query: CREATE TABLE mybb_importantmsgs ( mid int unsigned NOT NULL auto_increment, title varchar(255) NOT NULL default '', message text NOT NULL default '', usergroups varchar(40) NOT NULL default '-1', bgcolor varchar(20) NOT NULL default '', color varchar(20) NOT NULL default '', class varchar(20) NOT NULL default '', id varchar(20) NOT NULL default '', image varchar(50) NOT NULL default '', ord int(4) NOT NULL default '0', style int(1) NOT NULL default '0', global int(1) NOT NULL default '0', PRIMARY KEY (mid) ) TYPE=MyISAM;

then I delete mybb_importantmsgs table from mysql database and try to activate again but I get this message:


MySQL error: 1060
Duplicate column name 'canaddimportantmessage'
Query: ALTER TABLE mybb_adminoptions ADD canaddimportantmessage char(3) NOT NULL default '' AFTER `canrundbtools

Can any one help me on this error?

Run these two queries:

DROP TABLE mybb_importantmsgs;
ALTER TABLE mybb_adminoptions DROP canaddimportantmessage;

And activate it again