Wednesday, March 17, 2010

Table 'access' already exists

Database error in vBulletin :
Invalid SQL:
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
);
MySQL Error : Table 'access' already exists
Error Number
: 1050
Request Date
: Monday, November 16th 2009 @ 09:42:15 PM
Error Date
: Monday, November 16th 2009 @ 09:42:15 PM
Script
:......
Referrer :......
IP Address :.......
Username :
Classname : vB_Database
MySQL Version
: 5.0.81-community


Solve the problems


DELETE FROM access;
CREATE TABLE `access` (
`
userid` int(10) unsigned NOT NULL default '0',
`
forumid` smallint(5) unsigned NOT NULL default '0',
`
accessmask` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`userid`,`forumid`)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1;

No comments:

Post a Comment