removing query

if i have ran a query and need to remove it how would i go about it 1 query being

$DB_site->query("ALTER TABLE forum ADD info smallint(6) DEFAULT '0' NOT NULL");

thnx for help

[Erwin]

Run this query:

PHP Code:

ALTER TABLE forum DROP info; 


[almightyone]

well ive ran this over and over and nothing happened i think my best bet is to say screw this message board as im pissed with it and my host so oh well

[almightyone]

after running that many times i tried to readd some stuff with this table but it gets error
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE forum ADD info1 smallint(6) DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'info1'

now if i ran what you said above with replacing info with info1 why do i get error?

[Erwin]

Read the error message:

Invalid SQL: ALTER TABLE forum ADD info1 smallint(6) DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'info1'

You are trying to ADD a column in the forum table called "info1" but it's already there. Of course, you cannot add it again and again.

To remove that column, run this query:

PHP Code:

ALTER TABLE forum DROP info1 


Run it only once - you cannot drop a column again and again. Same with adding a column. Do it only once. What are you using to run queries?

[almightyone]

im running them in phpmyadmin i ran the drop and then ran the add and it gave the error it is already there but i ran drop first then ran add and got that error so drop isnt dropping

[Erwin]

Weird. If you have phpmyadmin, go to the "Forum" table, and just manually DROP the unwanted column. You can visually see it disappear. Then manually add it. That should work for sure.

[almightyone]

well i drop table but that column is part of it and i cant see it all i can see is the table itself i drop it with drop option but there is a column inside it not shown in phpmyadmin oh well im to pissed with it right now

[Erwin]

Yikes! Don't drop the table. Drop the column in the table. You need the forum table for your site. Maybe your database is corrupt.

[almightyone]

na the database isnt corrupt anyways i cant find the columns listed is the problem it wont delete the one and it also wont create another needed oh well