Database error in vBulletin 3.0.3:
Invalid SQL:
CREATE TABLE gamechallenges (
challengeid int(10) unsigned NOT NULL auto_increment,
type tinyint(1) unsigned NOT NULL default '0',
challengerid int(10) unsigned NOT NULL default '0',
challengedid int(10) unsigned NOT NULL default '0',
game varchar(30) NOT NULL default '',
status tinyint(1) unsigned NOT NULL default '0',
datestamp int(13) unsigned NOT NULL default '0',
challengersession int(20) unsigned NOT NULL default '0',
challengedsession int(20) unsigned NOT NULL default '0',
PRIMARY KEY (challengeid)
) TYPE=MyISAM
mysql error: Table 'gamechallenges' already exists
mysql error number: 1050
HELP!!!! Someone, anyone!
I have lastest verstion of arcade and VB 3.0.3. I just recently upgraded the site and had to reinstall the arcade.....
Seems that some of the left over databases are messing things up.
I tried to wipe all the databases but then get this error:
Invalid SQL:
INSERT INTO datastore VALUES('arcadesettings', 845)
mysql error: Duplicate entry 'arcadesettings' for key 1
mysql error number: 1062
|