anyone seen this one yet?
Quote:
Database error in vBulletin 3.0.7:
Invalid SQL:
CREATE TABLE quotes (
`quoteid` int(10) unsigned NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`author` mediumtext NOT NULL,
`userid` int(10) unsigned NOT NULL default '0',
`approved` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`quoteid`,`quoteid`),
KEY `approved` (`approved`)
) TYPE=MyISAM AUTO_INCREMENT=1
mysql error: Duplicate column name 'quoteid'
mysql error number: 1060
|