MyBB Community Forums

I get this message when I try to activate my download section.

What should I do?

MySQLi error: 1050
Table 'mybb_downloadcategories' already exists
Query: CREATE TABLE mybb_downloadcategories ( cid smallint unsigned NOT NULL auto_increment, name varchar(120) NOT NULL default '', description text NOT NULL default '', visiblegroups text NOT NULL default '', submissiongroups text NOT NULL default '', disporder smallint unsigned NOT NULL default '0', downloads int(10) NOT NULL default '0', PRIMARY KEY (cid) ) TYPE=MyISAM;

Delete the existing database tables using PhpMyAdmin or something and try again.

Please only post MyBB related problems here. No plugin issues please. Post those at the mods section.

When I delete the mybb_downloadcategories and mybb_downloads I get this error when I try to activate again.

MySQLi error: 1060
Duplicate column name 'canmanagedownloads'
Query: ALTER TABLE mybb_adminoptions ADD canmanagedownloads CHAR(3) NOT NULL default ''

Open the mybb_adminoptions and delete 'canmanagedownloads' too.

One step ahead of you. I did and didn't help

What error did you get then?

then there were other things that was duplicate.

You'd have to delete them all.

destroyer Wrote:You'd have to delete them all.

But I don't know all the things to delete.

I delete

mybb_downloadcategories
mybb_downloads
canmanagedownloads

and got this answer.

MySQLi error: 1054
Unknown column 'Pinkie' in 'where clause'
Query: UPDATE mybb_adminoptions SET canmanagedownloads='yes' WHERE uid IN (Pinkie)
What to do?