Why this error?

[Dark Aura]

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

[Jolten]

it means you already have a column named 'quote_id' in that table in your database.

[Dark Aura]

so what do I do? I have no idea about these things :-s!

[Marco van Herwaarden]

It means that the column 'quoteid' is used twice in the primairy key contraint.

I think i already posted this answer in the hack support thread.

[Marco van Herwaarden]

[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`),
KEY `approved` (`approved`)
) TYPE=MyISAM AUTO_INCREMENT=1
[/sql]Try this, although i don't know what the original coder wanted it to be.

[Dark Aura]

Okay so how do I get rid of my second column named quote_id I need a simple explanation, I mean simple lol! I have no idea what I am doing :nod:.