Everytime I try to run a query for this quote it hack I keep getting this error what ever it is, what is wrong with my database?
----------------
Database error in vBulletin 3.0.3:
Invalid SQL:
CREATE TABLE vb3_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
Date: Tuesday 29th of March 2005 02:09:54 PM
Script:
http://www.silent-imperfection.net/a...ll_quoteit.php
Referer:
http://www.silent-imperfection.net/a...ll_quoteit.php
Username: Spade
IP Address: 62.64.214.70