KoverPL

no naprawilem, wystarczylo dodac: ALTER TABLE pwf_members ADD COLUMN has_gallery tinyint(1) NOT NULL default '0' dzieki wielkie za pomoc, pozdrawiam

ok dodalem brakujace, pozostaje tylko to: Date: Wed, 15 Jul 2009 23:37:17 +0200 Error Number: 1054 Error: Unknown column 'has_gallery' in 'field list' IP Address: 84.195.9.11 Page: /oldforum/ mySQL query error: SELECT id, name, mgroup, member_login_key, member_login_key_expire, email, restrict_post, view_sigs, view_avs, view_pop, view_img, auto_track, mod_posts, language, skin, new_msg, show_popup, msg_total, time_offset, posts, joined, last_post, subs_pkg_chosen, ignored_users, login_anonymous, last_visit, last_activity, dst_in_use, view_prefs, org_perm_id, mgroup_others, temp_ban, sub_end, has_blog, has_gallery, members_markers, members_editor_choice, members_auto_dst, members_display_name, members_created_remote, members_cache, members_disable_pm FROM pwf_members WHERE id=1 w pliku mysql_tables.php niby normalnie tworzy ta kolumne ale jak jest na swoim miejscu to po co ja odrzuca ?

no mam plik: mysql_tables.php ale raczej tam sa funkcji w php czyli to automatycznie jakos dodaje ale czy sa one wyodrebnione ? bo jesli w pliku jets: $TABLE[] = "CREATE TABLE ibf_admin_login_logs ( admin_id INT(10) NOT NULL auto_increment, admin_ip_address VARCHAR(16) NOT NULL default '0.0.0.0', admin_username VARCHAR(40) NOT NULL default '', admin_time INT(10) UNSIGNED NOT NULL default '0', admin_success INT(1) UNSIGNED NOT NULL default '0', admin_post_details TEXT NULL, PRIMARY KEY (admin_id), KEY admin_ip_address (admin_ip_address), KEY admin_time (admin_time) );"; to dodac w sposob: CREATE TABLE ibf_admin_login_logs ( admin_id INT(10) NOT NULL auto_increment, admin_ip_address VARCHAR(16) NOT NULL default '0.0.0.0', admin_username VARCHAR(40) NOT NULL default '', admin_time INT(10) UNSIGNED NOT NULL default '0', admin_success INT(1) UNSIGNED NOT NULL default '0', admin_post_details TEXT NULL, PRIMARY KEY (admin_id), KEY admin_ip_address (admin_ip_address), KEY admin_time (admin_time) ); czy jak ?

ALTER TABLE pwf_members ADD COLUMN pwf_admin_login_logs INT(10) NOT NULL default '0'; tak po kolei ?

problem w tym ze jak wchodze do ACP po tym jak wpisze emaila i login to dostaje komunikat: IPS Driver Error There appears to be an error with the database. You can try to refresh the page by clicking here a w cache: Date: Wed, 15 Jul 2009 23:14:05 +0200 Error Number: 1146 Error: Table 'oldforum.pwf_admin_login_logs' doesn't exist IP Address: 84.195.9.11 Page: /oldforum/admin/index.php?adsess=&act=login&code=login-complete mySQL query error: INSERT INTO pwf_admin_login_logs (admin_ip_address,admin_username,admin_time,admin_success,admin_post_details) VALUES('84.195.9.11','[email protected]',1247692445,0,'a:2:{s:3:\"get\";a:3:{s:6:\"adsess\";s:0:\"\";s:3:\"act\";s:5:\ dziwnie ze szuka tabeli oldforum.pwf_admin_login_logs skoro powinno byc: pwf_admin_login_logs

teraz dostaje: =================================================== Date: Wed, 15 Jul 2009 23:10:22 +0200 Error Number: 1054 Error: Unknown column 'has_gallery' in 'field list' IP Address: 84.195.9.11 Page: /oldforum/ mySQL query error: SELECT id, name, mgroup, member_login_key, member_login_key_expire, email, restrict_post, view_sigs, view_avs, view_pop, view_img, auto_track, mod_posts, language, skin, new_msg, show_popup, msg_total, time_offset, posts, joined, last_post, subs_pkg_chosen, ignored_users, login_anonymous, last_visit, last_activity, dst_in_use, view_prefs, org_perm_id, mgroup_others, temp_ban, sub_end, has_blog, has_gallery, members_markers, members_editor_choice, members_auto_dst, members_display_name, members_created_remote, members_cache, members_disable_pm FROM pwf_members WHERE id=1

wpisuje to i dostaje komunikat: Błąd zapytanie SQL: ALTER TABLE pwf_members ADD COLUMN member_login_key varchar( 32 ) NOT NULL default ''; MySQL zwrócił komunikat: Dokumentacja #1060 - Duplicate column name 'member_login_key' A tak poza tym to po co ktos mial by usuwac ta tabele ?

W sumie to powiem tak, kiedsy mi forum ladnie smigalo to znaczy ta moja kopia a kiedsy wchodze i zostalo tlyko to, podejrzewam ze to byl wlam ale nei wiem kto i po co. Jak naprawic ?

hej, a co zrobic w wypadku: Date: Wed, 15 Jul 2009 17:27:35 +0200 Error Number: 1054 Error: Unknown column 'member_login_key_expire' in 'field list' IP Address: 84.195.9.11 Page: /oldforum/ mySQL query error: SELECT id, name, mgroup, member_login_key, member_login_key_expire, email, restrict_post, view_sigs, view_avs, view_pop, view_img, auto_track, mod_posts, language, skin, new_msg, show_popup, msg_total, time_offset, posts, joined, last_post, subs_pkg_chosen, ignored_users, login_anonymous, last_visit, last_activity, dst_in_use, view_prefs, org_perm_id, mgroup_others, temp_ban, sub_end, has_blog, has_gallery, members_markers, members_editor_choice, members_auto_dst, members_display_name, members_created_remote, members_cache, members_disable_pm FROM pwf_members WHERE id=1

wiec co moge zrobic jesli mam komunikat: IPS Driver Error There appears to be an error with the database. You can try to refresh the page by clicking here dokladnie w logu: =================================================== Date: Wed, 15 Jul 2009 17:27:35 +0200 Error Number: 1054 Error: Unknown column 'member_login_key_expire' in 'field list' IP Address: 84.195.9.11 Page: /oldforum/ mySQL query error: SELECT id, name, mgroup, member_login_key, member_login_key_expire, email, restrict_post, view_sigs, view_avs, view_pop, view_img, auto_track, mod_posts, language, skin, new_msg, show_popup, msg_total, time_offset, posts, joined, last_post, subs_pkg_chosen, ignored_users, login_anonymous, last_visit, last_activity, dst_in_use, view_prefs, org_perm_id, mgroup_others, temp_ban, sub_end, has_blog, has_gallery, members_markers, members_editor_choice, members_auto_dst, members_display_name, members_created_remote, members_cache, members_disable_pm FROM pwf_members WHERE id=1 Moim zdaniem musze poprostu upgradowac baze do 2.3.6 ale jak wchodze w upgrade nie przyjmuje mi hasla wiec dlatego mam problem bo chce zmienic haslo admina a nie moge nic zrobic

http://milw0rm.com/exploits/8538

a jaka jest komenda na zmiane hasla administratora glownego ? tylko tak abym mogl zrobic to z poziomu phpmyadmina