MyBB Community Forums

Full Version: Group Promotions
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I receive this error when clicking 'group promotions' in the ACP.

SQL Error:
1146 - Table 'tables_tables.mybb_promotions' doesn't exist
Query:
SELECT * FROM mybb_promotions ORDER BY title ASC

I dropped the table long ago, what's the easiest way to create it again with the proper settings?
CREATE TABLE mybb_promotions (
  pid int unsigned NOT NULL auto_increment,
  title varchar(120) NOT NULL default '',
  description text NOT NULL,
  enabled tinyint(1) NOT NULL default '1',
  logging tinyint(1) NOT NULL default '0',
  posts int NOT NULL default '0',
  posttype char(2) NOT NULL default '',
  registered int NOT NULL default '0',
  registeredtype varchar(20) NOT NULL default '',
  reputations int NOT NULL default '0',
  reputationtype char(2) NOT NULL default '',
  referrals int NOT NULL default '0',
  referralstype char(2) NOT NULL default '',
  requirements varchar(200) NOT NULL default '',
  originalusergroup varchar(120) NOT NULL default '0',
  newusergroup smallint unsigned NOT NULL default '0',
  usergrouptype varchar(120) NOT NULL default '0',
  PRIMARY KEY (pid)
) ENGINE=MyISAM;
Thank you.