vb.org Archive - How Can I Remove This Query?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - How Can I Remove This Query? (https://vborg.vbsupport.ru/showthread.php?t=45366)

ZiRu$

11-03-2002 11:18 PM

How Can I Remove This Query?

I dont know how :(

Code:

alter table user

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

Erwin

11-04-2002 12:08 AM

PHP Code:


		
			
alter table user drop enablewysiwyg;

Just change add to drop, and it should work. :)

ZiRu$

11-05-2002 02:39 AM

Dosent Work :(

I get this message

Code:

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

Code:

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

11-05-2002 03:58 AM

Try

PHP Code:


		
			
 DELETE FROM user WHERE ID=#

Where # is the number of the column.

What Erwin said should work, however.

Radon3k

11-05-2002 04:02 AM

[edit].[/edit]

Erwin

11-05-2002 10:20 AM

Quote:

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

Code:

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$

11-05-2002 02:36 PM

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

Radon3k

11-05-2002 02:46 PM

No, shouldn't need to.

Erwin

11-05-2002 05:24 PM

No.

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

All times are GMT. The time now is 06:19 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01022 seconds Memory Usage 1,727KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: