How Can I Remove This Query?

I dont know how

alter table user
add enablewysiwyg smallint(5) UNSIGNED not null default '0';

[Erwin]

PHP Code:

alter table user drop enablewysiwyg; 


Just change add to drop, and it should work.

[ZiRu$]

Dosent Work

I get this message

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: alter table user drop enablewysiwyg;
mysql error: Can't DROP 'enablewysiwyg'. Check that column/key exists

mysql error number: 1091

Heres the message i get when i try to click on reply or new thread

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT enablewysiwyg FROM user WHERE userid='1'
mysql error: Unknown column 'enablewysiwyg' in 'field list'

mysql error number: 1054

EDIT: Man i'm stupid...i realize it dont need to be dropped....its looking for it and CANT find it...But i removed the hack. How can i remove the reference to it ???

cause i no longer have this hack

[Radon3k]

Try

PHP Code:

 DELETE FROM user WHERE ID=# 


Where # is the number of the column.

What Erwin said should work, however.

[Radon3k]

[edit].[/edit]

[Erwin]

Originally posted by ZiRu$
Heres the message i get when i try to click on reply or new thread

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT enablewysiwyg FROM user WHERE userid='1'
mysql error: Unknown column 'enablewysiwyg' in 'field list'

mysql error number: 1054

EDIT: Man i'm stupid...i realize it dont need to be dropped....its looking for it and CANT find it...But i removed the hack. How can i remove the reference to it ???

cause i no longer have this hack

Open newreply.php,

Find: "enablewysiwyg"

When you find the query line with that variable in it, delete the whole section.

Do the same for newthread.php.

Done!

[ZiRu$]

thanks erwin i'll try............do i still run the query Raedon said to use?

[Radon3k]

No, shouldn't need to.

[Erwin]

No.

You took the column out of your db, but left the query statements still in those 2 files. Take them out as well.