Odinstalowanie "Advanced_Attach_Watermark_v_0_1_3_en"

[matius71]

Jeszcze chciałem usunąć mod "Advanced_Attach_Watermark_v_0_1_3_en" z mojego forum i chciałem zapytać się jakie trzeba podać polecenia aby usunąć go z bazy danych... polecenie brzmi tak:

Kod: Zaznacz cały

INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES
('watermark_on_off', '1', 0),
('watermark_backup_on_off', '1', 0),
('watermark_type', 'text', 0),
('watermark_output_quality', '100', 0),
('watermark_img_sz_proc', '50', 0),
('watermark_img_max_size', '1200x1200', 0),
('watermark_transparency', '50', 0),
('watermark_text_transparency', '70', 0),
('watermark_text', 'Copy-Wright', 0),
('watermark_text_size', '30', 0),
('watermark_text_font', 'comic.ttf', 0),
('watermark_text_color', '000000', 0),
('watermark_text_sha_color', 'FFF000', 0),
('watermark_sha_text_pos', '-2', 0),
('watermark_text_cut', '20', 0),
('watermark_text_degree', '45', 0),
('watermark_position', 'BM', 0),
('watermark_resize_only', '0', 0),
('watermark_resize', '0', 0),
('watermark_convert_only', '0', 0),
('watermark_convert', '0', 0),
('watermark_convert_high_only', '0', 0),
('watermark_convert_high', '0', 0),
('watermark_off_when_convert_on', '0', 0),
('watermark_resize_width', '400', 0),
('watermark_afterward_initial', '0', 0);

[jaroslw]

Kod: Zaznacz cały

DELETE FORM phpbb_config
WHERE config_name = 'watermark_on_off'
	AND config_name = 'watermark_backup_on_off'
	AND config_name = 'watermark_type'
	AND config_name = 'watermark_output_quality'
	AND config_name = 'watermark_img_sz_proc'
	AND config_name = 'watermark_img_max_size'
	AND config_name = 'watermark_transparency'
	AND config_name = 'watermark_text_transparency'
	AND config_name = 'watermark_text'
	AND config_name = 'watermark_text_size'
	AND config_name = 'watermark_text_font'
	AND config_name = 'watermark_text_color'
	AND config_name = 'watermark_text_sha_color'
	AND config_name = 'watermark_sha_text_pos'
	AND config_name = 'watermark_text_cut'
	AND config_name = 'watermark_text_degree'
	AND config_name = 'watermark_position'
	AND config_name = 'watermark_resize_only'
	AND config_name = 'watermark_resize'
	AND config_name = 'watermark_convert_only'
	AND config_name = 'watermark_convert'
	AND config_name = 'watermark_convert_high_only'
	AND config_name = 'watermark_convert_high'
	AND config_name = 'watermark_off_when_convert_on'
	AND config_name = 'watermark_resize_width'
	AND config_name = 'watermark_afterward_initial';

Polecam skorzystać z narzędzia Support Toolkit i opcji Database Cleaner.

[matius71]

Dzięki wielkie ;D

----Edit---

Nie bardzo działa...

Kod: Zaznacz cały

Błąd

zapytanie SQL:

DELETE FORM phpbb_config WHERE config_name = 'watermark_on_off' AND config_name = 'watermark_backup_on_off' AND config_name = 'watermark_type' AND config_name = 'watermark_output_quality' AND config_name = 'watermark_img_sz_proc' AND config_name = 'watermark_img_max_size' AND config_name = 'watermark_transparency' AND config_name = 'watermark_text_transparency' AND config_name = 'watermark_text' AND config_name = 'watermark_text_size' AND config_name = 'watermark_text_font' AND config_name = 'watermark_text_color' AND config_name = 'watermark_text_sha_color' AND config_name = 'watermark_sha_text_pos' AND config_name = 'watermark_text_cut' AND config_name = 'watermark_text_degree' AND config_name = 'watermark_position' AND config_name = 'watermark_resize_only' AND config_name = 'watermark_resize' AND config_name = 'watermark_convert_only' AND config_name = 'watermark_convert' AND config_name = 'watermar[...]

MySQL zwrócił komunikat: Dokumentacja
#1064 - Something is wrong in your syntax obok 'WHERE config_name = 'watermark_on_off'
   AND config_name = 'watermark_backup_o' w linii 2 

[jaroslw]

Rzeczywiście, zrobiłem to trochę mechanicznie, jak w zapytaniu SELECT. Nie jestem pewien czy będzie działać z OR zamiast AND, daję więc trochę inną wersję:

Kod: Zaznacz cały

DELETE FORM phpbb_config WHERE config_name = 'watermark_on_off';
DELETE FORM phpbb_config WHERE config_name = 'watermark_backup_on_off';
DELETE FORM phpbb_config WHERE config_name = 'watermark_type';
DELETE FORM phpbb_config WHERE config_name = 'watermark_output_quality';
DELETE FORM phpbb_config WHERE config_name = 'watermark_img_sz_proc';
DELETE FORM phpbb_config WHERE config_name = 'watermark_img_max_size';
DELETE FORM phpbb_config WHERE config_name = 'watermark_transparency';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_transparency';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_size';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_font';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_color';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_sha_color';
DELETE FORM phpbb_config WHERE config_name = 'watermark_sha_text_pos';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_cut';
DELETE FORM phpbb_config WHERE config_name = 'watermark_text_degree';
DELETE FORM phpbb_config WHERE config_name = 'watermark_position';
DELETE FORM phpbb_config WHERE config_name = 'watermark_resize_only';
DELETE FORM phpbb_config WHERE config_name = 'watermark_resize';
DELETE FORM phpbb_config WHERE config_name = 'watermark_convert_only';
DELETE FORM phpbb_config WHERE config_name = 'watermark_convert';
DELETE FORM phpbb_config WHERE config_name = 'watermark_convert_high_only';
DELETE FORM phpbb_config WHERE config_name = 'watermark_convert_high';
DELETE FORM phpbb_config WHERE config_name = 'watermark_off_when_convert_on';
DELETE FORM phpbb_config WHERE config_name = 'watermark_resize_width';
DELETE FORM phpbb_config WHERE config_name = 'watermark_afterward_initial';

[matius71]

Teraz też nie działa

Kod: Zaznacz cały

Błąd

zapytanie SQL:

DELETE FORM phpbb_config WHERE config_name = 'watermark_on_off';

MySQL zwrócił komunikat: Dokumentacja
#1064 - Something is wrong in your syntax obok 'WHERE config_name = 'watermark_on_off'' w linii 1 

[jaroslw]

Znowu przyzwyczajenie bierze górą Nazwy kolumn bez apostrofów.

Kod: Zaznacz cały

DELETE FORM phpbb_config WHERE config_name = watermark_on_off;
DELETE FORM phpbb_config WHERE config_name = watermark_backup_on_off;
DELETE FORM phpbb_config WHERE config_name = watermark_type;
DELETE FORM phpbb_config WHERE config_name = watermark_output_quality;
DELETE FORM phpbb_config WHERE config_name = watermark_img_sz_proc;
DELETE FORM phpbb_config WHERE config_name = watermark_img_max_size;
DELETE FORM phpbb_config WHERE config_name = watermark_transparency;
DELETE FORM phpbb_config WHERE config_name = watermark_text_transparency;
DELETE FORM phpbb_config WHERE config_name = watermark_text;
DELETE FORM phpbb_config WHERE config_name = watermark_text_size;
DELETE FORM phpbb_config WHERE config_name = watermark_text_font;
DELETE FORM phpbb_config WHERE config_name = watermark_text_color;
DELETE FORM phpbb_config WHERE config_name = watermark_text_sha_color;
DELETE FORM phpbb_config WHERE config_name = watermark_sha_text_pos;
DELETE FORM phpbb_config WHERE config_name = watermark_text_cut;
DELETE FORM phpbb_config WHERE config_name = watermark_text_degree;
DELETE FORM phpbb_config WHERE config_name = watermark_position;
DELETE FORM phpbb_config WHERE config_name = watermark_resize_only;
DELETE FORM phpbb_config WHERE config_name = watermark_resize;
DELETE FORM phpbb_config WHERE config_name = watermark_convert_only;
DELETE FORM phpbb_config WHERE config_name = watermark_convert;
DELETE FORM phpbb_config WHERE config_name = watermark_convert_high_only;
DELETE FORM phpbb_config WHERE config_name = watermark_convert_high;
DELETE FORM phpbb_config WHERE config_name = watermark_off_when_convert_on;
DELETE FORM phpbb_config WHERE config_name = watermark_resize_width;
DELETE FORM phpbb_config WHERE config_name = watermark_afterward_initial;

[matius71]

Źle

Kod: Zaznacz cały

Błąd

zapytanie SQL:

DELETE FORM phpbb_config WHERE config_name = watermark_on_off;

MySQL zwrócił komunikat: Dokumentacja
#1064 - Something is wrong in your syntax obok 'WHERE config_name = watermark_on_off' w linii 1

[jaroslw]

Tamtym razem już sprawdzałem, ale jeśli Ci nie działa, spróbuj z wersją w cudzysłowach. To już zależy od wersji MySQL (jak widać podawanie danych typu string nie jest do końca ustandaryzowane)

Kod: Zaznacz cały

DELETE FORM phpbb_config WHERE config_name = "watermark_on_off";
DELETE FORM phpbb_config WHERE config_name = "watermark_backup_on_off";
DELETE FORM phpbb_config WHERE config_name = "watermark_type";
DELETE FORM phpbb_config WHERE config_name = "watermark_output_quality";
DELETE FORM phpbb_config WHERE config_name = "watermark_img_sz_proc";
DELETE FORM phpbb_config WHERE config_name = "watermark_img_max_size";
DELETE FORM phpbb_config WHERE config_name = "watermark_transparency";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_transparency";
DELETE FORM phpbb_config WHERE config_name = "watermark_text";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_size";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_font";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_color";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_sha_color";
DELETE FORM phpbb_config WHERE config_name = "watermark_sha_text_pos";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_cut";
DELETE FORM phpbb_config WHERE config_name = "watermark_text_degree";
DELETE FORM phpbb_config WHERE config_name = "watermark_position";
DELETE FORM phpbb_config WHERE config_name = "watermark_resize_only";
DELETE FORM phpbb_config WHERE config_name = "watermark_resize";
DELETE FORM phpbb_config WHERE config_name = "watermark_convert_only";
DELETE FORM phpbb_config WHERE config_name = "watermark_convert";
DELETE FORM phpbb_config WHERE config_name = "watermark_convert_high_only";
DELETE FORM phpbb_config WHERE config_name = "watermark_convert_high";
DELETE FORM phpbb_config WHERE config_name = "watermark_off_when_convert_on";
DELETE FORM phpbb_config WHERE config_name = "watermark_resize_width";
DELETE FORM phpbb_config WHERE config_name = "watermark_afterward_initial";

[matius71]

Takie coś:

Kod: Zaznacz cały

Błąd

zapytanie SQL:

DELETE FORM phpbb_config WHERE config_name = "watermark_on_off";

MySQL zwrócił komunikat: Dokumentacja
#1064 - Something is wrong in your syntax obok 'WHERE config_name = "watermark_on_off"' w linii 1 

[jaroslw]

Poddaje się. Podane zapytania są zgodne ze specyfikacją SQL. Spróbuj wykonać je jeszcze pojedynczo. Jeśli tak nie pójdzie, wejdź w przegląd tabeli phpbb_config, zaznacz te kolumny i kliknij ikonkę usuń.

[matius71]

Pojedynczo też się nie chce usunąć...

A jak wchodzę w "phpbb_config" i znajdę te kolumny to jak ja mam zaznaczyć i je usunąć? Ja mam tylko taki obraz:

[jaroslw]

U Ciebie wygląda trochę dziwnie. Powinno to być coś w tym stylu:



Jaka to wersja phpMyAdmina? Logujesz się na konto o pełnych uprawnieniach? Polecę jeszcze raz użycie STK – wykaże Ci wszystkie niestandardowe wpisy w bazie danych, będziesz mógł zaznaczyć, które chcesz usunąć.

[matius71]

aa.... Dobra, dzięki za PS Bo ja robiłem tak że z kolumny tej z lewej wybierałem "phpbb_config" a to wystarczyło z głównego okna wybrać i już jest ok, już usunąłem, dzięki