Konwersja bazy danych

 

Strona 1 z 1 [ 9 posty(ów) ]

Widok do druku | « Poprzedni temat | Następny temat »

Temat

• Wysłany: 23 Maj 2006, 12:24

  Szuszar

  

  
  Rejestracja: 22 Maj 2006, 21:42
  Posty: 6
  mam pytanie. czy dało by się zmienić bazę danych do phpbb by przemo v. 1.9.5 na najnowsze phpbb2???

  

Odpowiedzi

• Wysłany: 23 Maj 2006, 12:30

  Orion

  

  

  
  Rejestracja: 14 Maj 2005, 10:31
  Posty: 1662
  Pochwały: 157
  dalo bty sie ... uzyj deinstalatora i wykonaj zapytania ktore dochodza w nowszych wersjach phpbb ( nie jestem pewien na ktorej wersji bazuje ta wersja przema )

  Autor postu otrzymał pochwałę

  ---

  Per aspera ad astra!
  Nie udzielam pomocy poza forum
  Kanał IRC: #phpbb @ irc.ircnet.pl

  

• Wysłany: 23 Maj 2006, 12:39

  Szuszar

  

  
  Rejestracja: 22 Maj 2006, 21:42
  Posty: 6
  a tak jaśniej możesz opisać bo jestem noobkiem jeśli chodzi o mysql...

  

• Wysłany: 23 Maj 2006, 12:44

  Orion

  

  

  
  Rejestracja: 14 Maj 2005, 10:31
  Posty: 1662
  Pochwały: 157
  http://www.przemo.org/phpBB2/index.php? ... #uninstall

  ---

  Per aspera ad astra!
  Nie udzielam pomocy poza forum
  Kanał IRC: #phpbb @ irc.ircnet.pl

  

• Wysłany: 23 Maj 2006, 12:51

  Szuszar

  

  
  Rejestracja: 22 Maj 2006, 21:42
  Posty: 6
  nie moge tam wejść bo dostałem bana... ale mam baze na dysku i chce wrzucić do nowego phpbb2 więc chyba deinstalacja nie jest potrzebna

  

• Wysłany: 23 Maj 2006, 13:16

  Orion

  

  

  
  Rejestracja: 14 Maj 2005, 10:31
  Posty: 1662
  Pochwały: 157
  wykonaj zapytania
  polecam wczesniej zrobic kopie bazy danych
  [sql]UPDATE phpbb_config SET config_value = '.0.20' WHERE config_name = 'version';
  CREATE TABLE phpbb_confirm (confirm_id char(32) DEFAULT '' NOT NULL, session_id char(32) DEFAULT '' NOT NULL, code char(6) DEFAULT '' NOT NULL, PRIMARY KEY (session_id, confirm_id));
  ALTER TABLE phpbb_users ADD COLUMN user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
  ALTER TABLE phpbb_users ADD COLUMN user_last_login_try int(11) DEFAULT '0' NOT NULL;
  ALTER TABLE phpbb_user_group DROP INDEX user_pending;
  ALTER TABLE phpbb_groups DROP INDEX group_type;
  ALTER TABLE phpbb_sessions DROP INDEX session_time;
  ALTER TABLE phpbb_topics DROP INDEX topic_poster;
  ALTER TABLE phpbb_topics DROP INDEX topic_last_post_id;
  ALTER TABLE phpbb_topics DROP INDEX topic_first_post_id;
  ALTER TABLE phpbb_topics DROP INDEX topic_vote;
  ALTER TABLE phpbb_users DROP INDEX user_level;
  ALTER TABLE phpbb_users DROP INDEX user_lastvisit;
  ALTER TABLE phpbb_users DROP INDEX user_active;
  ALTER TABLE phpbb_users ADD user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL;
  DROP TABLE phpbb_advertisement;
  DROP TABLE phpbb_adv_person;
  DROP TABLE phpbb_album;
  DROP TABLE phpbb_album_cat;
  DROP TABLE phpbb_album_comment;
  DROP TABLE phpbb_album_config;
  DROP TABLE phpbb_album_rate;
  DROP TABLE phpbb_anti_robotic_reg;
  DROP TABLE phpbb_attachments;
  DROP TABLE phpbb_attachments_config;
  DROP TABLE phpbb_attachments_desc;
  DROP TABLE phpbb_attach_quota;
  DROP TABLE phpbb_birthday;
  DROP TABLE phpbb_chatbox;
  DROP TABLE phpbb_chatbox_session;
  DROP TABLE phpbb_extensions;
  DROP TABLE phpbb_extension_groups;
  DROP TABLE phpbb_forbidden_extensions;
  DROP TABLE phpbb_ignores;
  DROP TABLE phpbb_jr_admin_users;
  DROP TABLE phpbb_logs;
  DROP TABLE phpbb_mass_email;
  DROP TABLE phpbb_pa_cat;
  DROP TABLE phpbb_pa_comments;
  DROP TABLE phpbb_pa_custom;
  DROP TABLE phpbb_pa_customdata;
  DROP TABLE phpbb_pa_files;
  DROP TABLE phpbb_pa_license;
  DROP TABLE phpbb_pa_settings;
  DROP TABLE phpbb_pa_votes;
  DROP TABLE phpbb_portal_config;
  DROP TABLE phpbb_posts_text_history;
  DROP TABLE phpbb_quota_limits;
  DROP TABLE phpbb_read_history;
  DROP TABLE phpbb_shoutbox;
  DROP TABLE phpbb_shoutbox_config;
  DROP TABLE phpbb_stats_config;
  DROP TABLE phpbb_stats_modules;
  DROP TABLE phpbb_topics_ignore;
  DROP TABLE phpbb_topic_view;
  DROP TABLE phpbb_users_warnings;
  ALTER TABLE phpbb_auth_access DROP auth_globalannounce;
  ALTER TABLE phpbb_auth_access DROP auth_download;
  ALTER TABLE phpbb_banlist DROP ban_time;
  ALTER TABLE phpbb_banlist DROP ban_expire_time;
  ALTER TABLE phpbb_banlist DROP ban_by_userid;
  ALTER TABLE phpbb_banlist DROP ban_priv_reason;
  ALTER TABLE phpbb_banlist DROP ban_pub_reason_mode;
  ALTER TABLE phpbb_banlist DROP ban_pub_reason;
  ALTER TABLE phpbb_banlist DROP ban_host;
  ALTER TABLE phpbb_categories DROP cat_main_type;
  ALTER TABLE phpbb_categories DROP cat_main;
  ALTER TABLE phpbb_categories DROP cat_desc;
  ALTER TABLE phpbb_forums DROP auth_globalannounce;
  ALTER TABLE phpbb_forums DROP auth_download;
  ALTER TABLE phpbb_forums DROP password;
  ALTER TABLE phpbb_forums DROP forum_sort;
  ALTER TABLE phpbb_forums DROP forum_color;
  ALTER TABLE phpbb_forums DROP forum_link;
  ALTER TABLE phpbb_forums DROP forum_link_internal;
  ALTER TABLE phpbb_forums DROP forum_link_hit_count;
  ALTER TABLE phpbb_forums DROP forum_link_hit;
  ALTER TABLE phpbb_forums DROP main_type;
  ALTER TABLE phpbb_forums DROP forum_moderate;
  ALTER TABLE phpbb_forums DROP no_count;
  ALTER TABLE phpbb_forums DROP forum_trash;
  ALTER TABLE phpbb_forums DROP forum_separate;
  ALTER TABLE phpbb_forums DROP forum_show_ga;
  ALTER TABLE phpbb_forums DROP forum_tree_grade;
  ALTER TABLE phpbb_forums DROP forum_tree_req;
  ALTER TABLE phpbb_forums DROP forum_no_split;
  ALTER TABLE phpbb_forums DROP forum_no_helped;
  ALTER TABLE phpbb_forums DROP topic_tags;
  ALTER TABLE phpbb_forums DROP locked_bottom;
  ALTER TABLE phpbb_groups DROP group_order;
  ALTER TABLE phpbb_groups DROP group_count;
  ALTER TABLE phpbb_groups DROP group_count_enable;
  ALTER TABLE phpbb_groups DROP group_mail_enable;
  ALTER TABLE phpbb_groups DROP group_no_unsub;
  ALTER TABLE phpbb_groups DROP group_color;
  ALTER TABLE phpbb_groups DROP group_prefix;
  ALTER TABLE phpbb_groups DROP group_style;
  ALTER TABLE phpbb_posts DROP post_attachment;
  ALTER TABLE phpbb_posts DROP user_agent;
  ALTER TABLE phpbb_posts DROP post_icon;
  ALTER TABLE phpbb_posts DROP post_expire;
  ALTER TABLE phpbb_posts DROP reporter_id;
  ALTER TABLE phpbb_posts DROP post_marked;
  ALTER TABLE phpbb_posts DROP post_approve;
  ALTER TABLE phpbb_posts DROP poster_delete;
  ALTER TABLE phpbb_posts DROP post_edit_by;
  ALTER TABLE phpbb_posts DROP post_parent;
  ALTER TABLE phpbb_posts DROP post_order;
  ALTER TABLE phpbb_privmsgs DROP privmsgs_attachment;
  ALTER TABLE phpbb_ranks DROP rank_group;
  ALTER TABLE phpbb_smilies DROP smile_order;
  ALTER TABLE phpbb_themes DROP tr_color_helped;
  ALTER TABLE phpbb_themes DROP fontcolor_admin;
  ALTER TABLE phpbb_themes DROP fontcolor_jradmin;
  ALTER TABLE phpbb_themes DROP fontcolor_mod;
  ALTER TABLE phpbb_themes DROP factive_color;
  ALTER TABLE phpbb_themes DROP faonmouse_color;
  ALTER TABLE phpbb_themes DROP faonmouse2_color;
  ALTER TABLE phpbb_topics DROP topic_attachment;
  ALTER TABLE phpbb_topics DROP topic_icon;
  ALTER TABLE phpbb_topics DROP topic_expire;
  ALTER TABLE phpbb_topics DROP topic_color;
  ALTER TABLE phpbb_topics DROP topic_title_e;
  ALTER TABLE phpbb_topics DROP topic_action;
  ALTER TABLE phpbb_topics DROP topic_action_user;
  ALTER TABLE phpbb_topics DROP topic_action_date;
  ALTER TABLE phpbb_topics DROP topic_tree_width;
  ALTER TABLE phpbb_users DROP user_allowsig;
  ALTER TABLE phpbb_users DROP user_viewaim;
  ALTER TABLE phpbb_users DROP user_sig_image;
  ALTER TABLE phpbb_users DROP user_birthday;
  ALTER TABLE phpbb_users DROP user_next_birthday_greeting;
  ALTER TABLE phpbb_users DROP user_custom_rank;
  ALTER TABLE phpbb_users DROP user_photo;
  ALTER TABLE phpbb_users DROP user_photo_type;
  ALTER TABLE phpbb_users DROP user_custom_color;
  ALTER TABLE phpbb_users DROP user_badlogin;
  ALTER TABLE phpbb_users DROP user_blocktime;
  ALTER TABLE phpbb_users DROP user_block_by;
  ALTER TABLE phpbb_users DROP disallow_forums;
  ALTER TABLE phpbb_users DROP can_custom_ranks;
  ALTER TABLE phpbb_users DROP can_custom_color;
  ALTER TABLE phpbb_users DROP user_gender;
  ALTER TABLE phpbb_users DROP can_topic_color;
  ALTER TABLE phpbb_users DROP user_notify_gg;
  ALTER TABLE phpbb_users DROP allowpm;
  ALTER TABLE phpbb_users DROP no_report_popup;
  ALTER TABLE phpbb_users DROP refresh_report_popup;
  ALTER TABLE phpbb_users DROP no_report_mail;
  ALTER TABLE phpbb_users DROP user_avatar_width;
  ALTER TABLE phpbb_users DROP user_avatar_height;
  ALTER TABLE phpbb_users DROP special_rank;
  ALTER TABLE phpbb_users DROP user_allow_helped;
  ALTER TABLE phpbb_users DROP user_ip;
  ALTER TABLE phpbb_users DROP user_ip_login_check;
  ALTER TABLE phpbb_users DROP user_spend_time;
  ALTER TABLE phpbb_users DROP user_visit;
  ALTER TABLE phpbb_users DROP user_session_start;
  ALTER TABLE phpbb_users DROP read_tracking_last_update;
  ALTER TABLE phpbb_users DROP user_jr;
  ALTER TABLE phpbb_vote_desc DROP vote_max;
  ALTER TABLE phpbb_vote_desc DROP vote_voted;
  ALTER TABLE phpbb_vote_desc DROP vote_hide;
  ALTER TABLE phpbb_vote_desc DROP vote_tothide;
  ALTER TABLE phpbb_vote_voters DROP vote_cast;
  DELETE FROM phpbb_config WHERE config_name = 'sendmail_fix';
  DELETE FROM phpbb_config WHERE config_name = 'allow_autologin';
  DELETE FROM phpbb_config WHERE config_name = 'allow_photo_remote';
  DELETE FROM phpbb_config WHERE config_name = 'allow_photo_upload';
  DELETE FROM phpbb_config WHERE config_name = 'photo_filesize';
  DELETE FROM phpbb_config WHERE config_name = 'photo_max_height';
  DELETE FROM phpbb_config WHERE config_name = 'photo_max_width';
  DELETE FROM phpbb_config WHERE config_name = 'photo_path';
  DELETE FROM phpbb_config WHERE config_name = 'allow_custom_rank';
  DELETE FROM phpbb_config WHERE config_name = 'birthday_greeting';
  DELETE FROM phpbb_config WHERE config_name = 'max_user_age';
  DELETE FROM phpbb_config WHERE config_name = 'min_user_age';
  DELETE FROM phpbb_config WHERE config_name = 'birthday_check_day';
  DELETE FROM phpbb_config WHERE config_name = 'cload';
  DELETE FROM phpbb_config WHERE config_name = 'cchat';
  DELETE FROM phpbb_config WHERE config_name = 'cstat';
  DELETE FROM phpbb_config WHERE config_name = 'cregist';
  DELETE FROM phpbb_config WHERE config_name = 'cstyles';
  DELETE FROM phpbb_config WHERE config_name = 'ccount';
  DELETE FROM phpbb_config WHERE config_name = 'cchat2';
  DELETE FROM phpbb_config WHERE config_name = 'cbirth';
  DELETE FROM phpbb_config WHERE config_name = 'cpost';
  DELETE FROM phpbb_config WHERE config_name = 'ctop';
  DELETE FROM phpbb_config WHERE config_name = 'cfriend';
  DELETE FROM phpbb_config WHERE config_name = 'cage';
  DELETE FROM phpbb_config WHERE config_name = 'cjoin';
  DELETE FROM phpbb_config WHERE config_name = 'cfrom';
  DELETE FROM phpbb_config WHERE config_name = 'cposts';
  DELETE FROM phpbb_config WHERE config_name = 'clevell';
  DELETE FROM phpbb_config WHERE config_name = 'cleveld';
  DELETE FROM phpbb_config WHERE config_name = 'cignore';
  DELETE FROM phpbb_config WHERE config_name = 'cquick';
  DELETE FROM phpbb_config WHERE config_name = 'cgg';
  DELETE FROM phpbb_config WHERE config_name = 'csearch';
  DELETE FROM phpbb_config WHERE config_name = 'cicq';
  DELETE FROM phpbb_config WHERE config_name = 'cllogin';
  DELETE FROM phpbb_config WHERE config_name = 'clevelp';
  DELETE FROM phpbb_config WHERE config_name = 'cyahoo';
  DELETE FROM phpbb_config WHERE config_name = 'cmsn';
  DELETE FROM phpbb_config WHERE config_name = 'cjob';
  DELETE FROM phpbb_config WHERE config_name = 'cinter';
  DELETE FROM phpbb_config WHERE config_name = 'cemail';
  DELETE FROM phpbb_config WHERE config_name = 'cbbcode';
  DELETE FROM phpbb_config WHERE config_name = 'chtml';
  DELETE FROM phpbb_config WHERE config_name = 'csmiles';
  DELETE FROM phpbb_config WHERE config_name = 'clang';
  DELETE FROM phpbb_config WHERE config_name = 'ctimezone';
  DELETE FROM phpbb_config WHERE config_name = 'cbstyle';
  DELETE FROM phpbb_config WHERE config_name = 'refresh';
  DELETE FROM phpbb_config WHERE config_name = 'meta_keywords';
  DELETE FROM phpbb_config WHERE config_name = 'meta_description';
  DELETE FROM phpbb_config WHERE config_name = 'cavatar';
  DELETE FROM phpbb_config WHERE config_name = 'clog';
  DELETE FROM phpbb_config WHERE config_name = 'cagent';
  DELETE FROM phpbb_config WHERE config_name = 'login_require';
  DELETE FROM phpbb_config WHERE config_name = 'crestrict';
  DELETE FROM phpbb_config WHERE config_name = 'validate';
  DELETE FROM phpbb_config WHERE config_name = 'button_b';
  DELETE FROM phpbb_config WHERE config_name = 'button_i';
  DELETE FROM phpbb_config WHERE config_name = 'button_u';
  DELETE FROM phpbb_config WHERE config_name = 'button_q';
  DELETE FROM phpbb_config WHERE config_name = 'button_c';
  DELETE FROM phpbb_config WHERE config_name = 'button_l';
  DELETE FROM phpbb_config WHERE config_name = 'button_im';
  DELETE FROM phpbb_config WHERE config_name = 'button_ur';
  DELETE FROM phpbb_config WHERE config_name = 'button_ce';
  DELETE FROM phpbb_config WHERE config_name = 'button_f';
  DELETE FROM phpbb_config WHERE config_name = 'button_s';
  DELETE FROM phpbb_config WHERE config_name = 'button_hi';
  DELETE FROM phpbb_config WHERE config_name = 'color_box';
  DELETE FROM phpbb_config WHERE config_name = 'size_box';
  DELETE FROM phpbb_config WHERE config_name = 'glow_box';
  DELETE FROM phpbb_config WHERE config_name = 'freak';
  DELETE FROM phpbb_config WHERE config_name = 'allow_bbcode_quest';
  DELETE FROM phpbb_config WHERE config_name = 'sql';
  DELETE FROM phpbb_config WHERE config_name = 'cregist_b';
  DELETE FROM phpbb_config WHERE config_name = 'allow_custom_color';
  DELETE FROM phpbb_config WHERE config_name = 'custom_color_view';
  DELETE FROM phpbb_config WHERE config_name = 'custom_color_use';
  DELETE FROM phpbb_config WHERE config_name = 'post_icon';
  DELETE FROM phpbb_config WHERE config_name = 'auto_date';
  DELETE FROM phpbb_config WHERE config_name = 'newest';
  DELETE FROM phpbb_config WHERE config_name = 'download';
  DELETE FROM phpbb_config WHERE config_name = 'ipview';
  DELETE FROM phpbb_config WHERE config_name = 'show_badwords';
  DELETE FROM phpbb_config WHERE config_name = 'album_gallery';
  DELETE FROM phpbb_config WHERE config_name = 'address_whois';
  DELETE FROM phpbb_config WHERE config_name = 'u_o_t_d';
  DELETE FROM phpbb_config WHERE config_name = 'expire';
  DELETE FROM phpbb_config WHERE config_name = 'expire_value';
  DELETE FROM phpbb_config WHERE config_name = 'numer_gg';
  DELETE FROM phpbb_config WHERE config_name = 'haslo_gg';
  DELETE FROM phpbb_config WHERE config_name = 'block_time';
  DELETE FROM phpbb_config WHERE config_name = 'max_login_error';
  DELETE FROM phpbb_config WHERE config_name = 'min_password_len';
  DELETE FROM phpbb_config WHERE config_name = 'force_complex_password';
  DELETE FROM phpbb_config WHERE config_name = 'password_not_login';
  DELETE FROM phpbb_config WHERE config_name = 'del_user_notify';
  DELETE FROM phpbb_config WHERE config_name = 'require_aim';
  DELETE FROM phpbb_config WHERE config_name = 'require_website';
  DELETE FROM phpbb_config WHERE config_name = 'require_location';
  DELETE FROM phpbb_config WHERE config_name = 'post_footer';
  DELETE FROM phpbb_config WHERE config_name = 'graphic';
  DELETE FROM phpbb_config WHERE config_name = 'max_sig_custom_rank';
  DELETE FROM phpbb_config WHERE config_name = 'max_sig_location';
  DELETE FROM phpbb_config WHERE config_name = 'custom_color_mod';
  DELETE FROM phpbb_config WHERE config_name = 'custom_rank_mod';
  DELETE FROM phpbb_config WHERE config_name = 'allow_sig_image';
  DELETE FROM phpbb_config WHERE config_name = 'sig_images_path';
  DELETE FROM phpbb_config WHERE config_name = 'sig_image_filesize';
  DELETE FROM phpbb_config WHERE config_name = 'sig_image_max_width';
  DELETE FROM phpbb_config WHERE config_name = 'sig_image_max_height';
  DELETE FROM phpbb_config WHERE config_name = 'hide_viewed_admin';
  DELETE FROM phpbb_config WHERE config_name = 'hide_edited_admin';
  DELETE FROM phpbb_config WHERE config_name = 'who_viewed';
  DELETE FROM phpbb_config WHERE config_name = 'who_viewed_admin';
  DELETE FROM phpbb_config WHERE config_name = 'edit_time';
  DELETE FROM phpbb_config WHERE config_name = 'gender';
  DELETE FROM phpbb_config WHERE config_name = 'require_gender';
  DELETE FROM phpbb_config WHERE config_name = 'main_admin_id';
  DELETE FROM phpbb_config WHERE config_name = 'day_to_prune';
  DELETE FROM phpbb_config WHERE config_name = 'banner_top';
  DELETE FROM phpbb_config WHERE config_name = 'banner_top_enable';
  DELETE FROM phpbb_config WHERE config_name = 'banner_bottom';
  DELETE FROM phpbb_config WHERE config_name = 'banner_bottom_enable';
  DELETE FROM phpbb_config WHERE config_name = 'header_enable';
  DELETE FROM phpbb_config WHERE config_name = 'not_edit_admin';
  DELETE FROM phpbb_config WHERE config_name = 'staff_forums';
  DELETE FROM phpbb_config WHERE config_name = 'staff_enable';
  DELETE FROM phpbb_config WHERE config_name = 'smilies_columns';
  DELETE FROM phpbb_config WHERE config_name = 'smilies_rows';
  DELETE FROM phpbb_config WHERE config_name = 'smilies_w_columns';
  DELETE FROM phpbb_config WHERE config_name = 'generate_time';
  DELETE FROM phpbb_config WHERE config_name = 'name_color';
  DELETE FROM phpbb_config WHERE config_name = 'desc_color';
  DELETE FROM phpbb_config WHERE config_name = 'mod_nick_color';
  DELETE FROM phpbb_config WHERE config_name = 'warnings_enable';
  DELETE FROM phpbb_config WHERE config_name = 'mod_warnings';
  DELETE FROM phpbb_config WHERE config_name = 'mod_edit_warnings';
  DELETE FROM phpbb_config WHERE config_name = 'mod_value_warning';
  DELETE FROM phpbb_config WHERE config_name = 'write_warnings';
  DELETE FROM phpbb_config WHERE config_name = 'ban_warnings';
  DELETE FROM phpbb_config WHERE config_name = 'expire_warnings';
  DELETE FROM phpbb_config WHERE config_name = 'warnings_mod_public';
  DELETE FROM phpbb_config WHERE config_name = 'viewtopic_warnings';
  DELETE FROM phpbb_config WHERE config_name = 'board_msg_enable';
  DELETE FROM phpbb_config WHERE config_name = 'board_msg';
  DELETE FROM phpbb_config WHERE config_name = 'width_forum';
  DELETE FROM phpbb_config WHERE config_name = 'width_table';
  DELETE FROM phpbb_config WHERE config_name = 'width_color1';
  DELETE FROM phpbb_config WHERE config_name = 'width_color2';
  DELETE FROM phpbb_config WHERE config_name = 'table_border';
  DELETE FROM phpbb_config WHERE config_name = 'rbuild_search';
  DELETE FROM phpbb_config WHERE config_name = 'generate_time_admin';
  DELETE FROM phpbb_config WHERE config_name = 'r_a_r_time';
  DELETE FROM phpbb_config WHERE config_name = 'visitors';
  DELETE FROM phpbb_config WHERE config_name = 'email_return_path';
  DELETE FROM phpbb_config WHERE config_name = 'email_from';
  DELETE FROM phpbb_config WHERE config_name = 'poster_posts';
  DELETE FROM phpbb_config WHERE config_name = 'sub_forum';
  DELETE FROM phpbb_config WHERE config_name = 'sub_forum_over';
  DELETE FROM phpbb_config WHERE config_name = 'split_cat';
  DELETE FROM phpbb_config WHERE config_name = 'split_cat_over';
  DELETE FROM phpbb_config WHERE config_name = 'last_topic_title';
  DELETE FROM phpbb_config WHERE config_name = 'last_topic_title_over';
  DELETE FROM phpbb_config WHERE config_name = 'last_topic_title_length';
  DELETE FROM phpbb_config WHERE config_name = 'sub_level_links';
  DELETE FROM phpbb_config WHERE config_name = 'sub_level_links_over';
  DELETE FROM phpbb_config WHERE config_name = 'display_viewonline';
  DELETE FROM phpbb_config WHERE config_name = 'display_viewonline_over';
  DELETE FROM phpbb_config WHERE config_name = 'ignore_topics';
  DELETE FROM phpbb_config WHERE config_name = 'topic_color';
  DELETE FROM phpbb_config WHERE config_name = 'topic_color_all';
  DELETE FROM phpbb_config WHERE config_name = 'topic_color_mod';
  DELETE FROM phpbb_config WHERE config_name = 'allow_sig_image_img';
  DELETE FROM phpbb_config WHERE config_name = 'last_dtable_notify';
  DELETE FROM phpbb_config WHERE config_name = 'report_no_guestes';
  DELETE FROM phpbb_config WHERE config_name = 'report_no_auth_users';
  DELETE FROM phpbb_config WHERE config_name = 'report_no_auth_groups';
  DELETE FROM phpbb_config WHERE config_name = 'report_disabled_users';
  DELETE FROM phpbb_config WHERE config_name = 'report_disabled_groups';
  DELETE FROM phpbb_config WHERE config_name = 'report_only_admin';
  DELETE FROM phpbb_config WHERE config_name = 'report_popup_height';
  DELETE FROM phpbb_config WHERE config_name = 'report_popup_width';
  DELETE FROM phpbb_config WHERE config_name = 'report_popup_links_target';
  DELETE FROM phpbb_config WHERE config_name = 'report_disable';
  DELETE FROM phpbb_config WHERE config_name = 'allow_avatar';
  DELETE FROM phpbb_config WHERE config_name = 'last_visitors_time';
  DELETE FROM phpbb_config WHERE config_name = 'max_sig_chars_admin';
  DELETE FROM phpbb_config WHERE config_name = 'max_sig_chars_mod';
  DELETE FROM phpbb_config WHERE config_name = 'viewonline';
  DELETE FROM phpbb_config WHERE config_name = 'restrict_smilies';
  DELETE FROM phpbb_config WHERE config_name = 'topic_preview';
  DELETE FROM phpbb_config WHERE config_name = 'not_anonymous_posting';
  DELETE FROM phpbb_config WHERE config_name = 'not_anonymous_quickreply';
  DELETE FROM phpbb_config WHERE config_name = 'max_smilies';
  DELETE FROM phpbb_config WHERE config_name = 'portal_link';
  DELETE FROM phpbb_config WHERE config_name = 'search_enable';
  DELETE FROM phpbb_config WHERE config_name = 'overlib';
  DELETE FROM phpbb_config WHERE config_name = 'notify_gg';
  DELETE FROM phpbb_config WHERE config_name = 'admin_notify_gg';
  DELETE FROM phpbb_config WHERE config_name = 'admin_notify_reply';
  DELETE FROM phpbb_config WHERE config_name = 'admin_notify_message';
  DELETE FROM phpbb_config WHERE config_name = 'topic_start_date';
  DELETE FROM phpbb_config WHERE config_name = 'topic_start_dateformat';
  DELETE FROM phpbb_config WHERE config_name = 'autorepair_tables';
  DELETE FROM phpbb_config WHERE config_name = 'check_address';
  DELETE FROM phpbb_config WHERE config_name = 'echange_banner';
  DELETE FROM phpbb_config WHERE config_name = 'banners_list';
  DELETE FROM phpbb_config WHERE config_name = 'split_messages';
  DELETE FROM phpbb_config WHERE config_name = 'split_messages_admin';
  DELETE FROM phpbb_config WHERE config_name = 'split_messages_mod';
  DELETE FROM phpbb_config WHERE config_name = 'admin_html';
  DELETE FROM phpbb_config WHERE config_name = 'jr_admin_html';
  DELETE FROM phpbb_config WHERE config_name = 'mod_html';
  DELETE FROM phpbb_config WHERE config_name = 'helped';
  DELETE FROM phpbb_config WHERE config_name = 'del_notify_method';
  DELETE FROM phpbb_config WHERE config_name = 'del_notify_enable';
  DELETE FROM phpbb_config WHERE config_name = 'del_notify_choice';
  DELETE FROM phpbb_config WHERE config_name = 'open_in_windows';
  DELETE FROM phpbb_config WHERE config_name = 'title_explain';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_unlocked';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_locked';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_moved';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_expired';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_edited_by_others';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_edited_self';
  DELETE FROM phpbb_config WHERE config_name = 'show_action_edited_self_all';
  DELETE FROM phpbb_config WHERE config_name = 'allow_mod_delete_actions';
  DELETE FROM phpbb_config WHERE config_name = 'show_rules';
  DELETE FROM phpbb_config WHERE config_name = 'mod_spy';
  DELETE FROM phpbb_config WHERE config_name = 'mod_spy_admin';
  DELETE FROM phpbb_config WHERE config_name = 'post_overlib';
  DELETE FROM phpbb_config WHERE config_name = 'ph_days';
  DELETE FROM phpbb_config WHERE config_name = 'ph_len';
  DELETE FROM phpbb_config WHERE config_name = 'ph_mod';
  DELETE FROM phpbb_config WHERE config_name = 'ph_mod_delete';
  DELETE FROM phpbb_config WHERE config_name = 'newestuser';
  DELETE FROM phpbb_config WHERE config_name = 'topiccount';
  DELETE FROM phpbb_config WHERE config_name = 'postcount';
  DELETE FROM phpbb_config WHERE config_name = 'usercount';
  DELETE FROM phpbb_config WHERE config_name = 'lastpost';
  DELETE FROM phpbb_config WHERE config_name = 'anonymous_simple';
  DELETE FROM phpbb_config WHERE config_name = 'onmouse';
  DELETE FROM phpbb_config WHERE config_name = 'birthday_data';
  DELETE FROM phpbb_config WHERE config_name = 'data';
  DELETE FROM phpbb_config WHERE config_name = 'last_resync';
  DELETE FROM phpbb_config WHERE config_name = 'advert';
  DELETE FROM phpbb_config WHERE config_name = 'advert_foot';
  DELETE FROM phpbb_config WHERE config_name = 'view_ad_by';
  DELETE FROM phpbb_config WHERE config_name = 'advert_width';
  DELETE FROM phpbb_config WHERE config_name = 'advert_separator';
  DELETE FROM phpbb_config WHERE config_name = 'advert_separator_l';
  DELETE FROM phpbb_config WHERE config_name = 'adv_person_time';
  DELETE FROM phpbb_config WHERE config_name = 'group_rank_hack_version';
  DELETE FROM phpbb_config WHERE config_name = 'disable_type';
  DELETE FROM phpbb_config WHERE config_name = 'xs_auto_compile';
  DELETE FROM phpbb_config WHERE config_name = 'xs_auto_recompile';
  DELETE FROM phpbb_config WHERE config_name = 'xs_use_cache';
  DELETE FROM phpbb_config WHERE config_name = 'xs_php';
  DELETE FROM phpbb_config WHERE config_name = 'xs_def_template';
  DELETE FROM phpbb_config WHERE config_name = 'xs_check_switches';
  DELETE FROM phpbb_config WHERE config_name = 'xs_warn_includes';
  DELETE FROM phpbb_config WHERE config_name = 'xs_ftp_host';
  DELETE FROM phpbb_config WHERE config_name = 'xs_ftp_login';
  DELETE FROM phpbb_config WHERE config_name = 'xs_ftp_path';
  DELETE FROM phpbb_config WHERE config_name = 'xs_downloads_count';
  DELETE FROM phpbb_config WHERE config_name = 'xs_downloads_default';
  DELETE FROM phpbb_config WHERE config_name = 'xs_shownav';
  DELETE FROM phpbb_config WHERE config_name = 'xs_template_time';
  DELETE FROM phpbb_config WHERE config_name = 'xs_version';
  DELETE FROM phpbb_config WHERE config_name = 'rh_without_days';
  DELETE FROM phpbb_config WHERE config_name = 'rh_max_posts';
  DELETE FROM phpbb_config WHERE config_name = 'public_category';[/sql]

  ---

  Per aspera ad astra!
  Nie udzielam pomocy poza forum
  Kanał IRC: #phpbb @ irc.ircnet.pl

  

• Wysłany: 23 Maj 2006, 13:33

  Szuszar

  

  
  Rejestracja: 22 Maj 2006, 21:42
  Posty: 6
  czyli tak. wgraywam najnowsze phpbb2, (załóżmy ze mam pustą baze danych) i teraz co:
  
  zainstalować najpierw i potem nadpisać baze danych tą moją? czy najpierw wgrać? czy jak?

  

• Wysłany: 23 Maj 2006, 13:41

  Orion

  

  

  
  Rejestracja: 14 Maj 2005, 10:31
  Posty: 1662
  Pochwały: 157
  http://www.phpbb2.pl/faq.php?faq=35

  ---

  Per aspera ad astra!
  Nie udzielam pomocy poza forum
  Kanał IRC: #phpbb @ irc.ircnet.pl

  

• Wysłany: 23 Maj 2006, 20:46

  Szuszar

  

  
  Rejestracja: 22 Maj 2006, 21:42
  Posty: 6
  robie wg poradnika i mi takie coś wyskakuje gdy chce importować baze w phpmyadminie:
  
  
  Błąd
  
  zapytanie SQL:
  
  CREATE TABLE phpbb_admin_notes(
  text text
  );
  
  
  
  MySQL zwrócił komunikat:
  #1044 - Access denied for user 'iwanowice'@'%' to database 'iwanowice'
  
  [
  
  
  
  a pod tym:
  
  Warning: Unknown: The session id contains illegal characters, valid characters are a-z, A-Z, 0-9 and '-,' in Unknown on line 0
  
  Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0
  
  
  gdzie popełniam błąd?
  
  [ Dodano: 24 Maj 2006 20:23 ]
  dobra już wrzuciłem pliki na inny serwer i jest elegancko z baza bo sie wgrała... postapiłem wg portadkina wgrywając baze z forum by przemo i wrzuciłem pliki do najnowszego phpbb2 ale jakoś nie działaja razem...
  
  a teraz jak wykonuje to zapytanie które mi podałeś ukazuje się taki błąd:
  
  błąd
  
  zapytanie SQL:
  
  CREATE TABLE phpbb_confirm(
  confirm_id CHAR( 32 ) DEFAULT '' NOT NULL ,
  session_id CHAR( 32 ) DEFAULT '' NOT NULL ,
  code CHAR( 6 ) DEFAULT '' NOT NULL ,
  PRIMARY KEY ( session_id, confirm_id )
  );
  
  
  
  MySQL zwrócił komunikat:
  #1050 - Table 'phpbb_confirm' already exists

  

 

Strona 1 z 1 [ 9 posty(ów) ]