How Can I Remove This Query?

[ZiRu$]

I dont know how :(


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

[Erwin]

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 DELETE FROM user WHERE ID=#

Where # is the number of the column.

What Erwin said should work, however.

[Radon3k]

.

[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.