UPDATE von mlf 2.0beta19 zu 2.2.7 nicht hinbekommen (German / Deutsch)
Hi,
... nie gehabt !
Okay, dann geht natürlich meine Idee nicht mehr. Die ging ja davon aus, dass Du von beta-19 auf beta-20 gehst und dann erst auf die aktuelle.
Um gleich von beta-19 auf die aktuelle zu kommen, habe ich 2mal folgendes erfolgreich gemacht:
1. Du installierst die 2.0beta-19 ganz normal ggf. den templates_c
-Ordner manuell erstellen
2. Du sicherst die Datei config/db_settings.php
3. Du löscht den Inhalt des Forum-Ordners
4. Du kopierst alle Dateien/Ordner der aktuellen 2.2.7 auf den Server in diesen Forum-Ordner
5. Du überschreibst die gesicherte Datei config/db_settings.php
wieder
6. Du führst alle bisherigen SQL-Updates durch (siehe unten)
7. Probiere, ob alles funktioniert hat
Gruß Micha
/* -- 2.0 beta 19 to 2.0 beta 20 -- CAUTION: edited_by values will be lost! Use update script to keep them. */ ALTER TABLE mlf2_entries CHANGE edited_by edited_by VARCHAR(255) NULL; UPDATE mlf2_entries SET TIME=TIME,last_reply=last_reply,edited=edited,edited_by=NULL; ALTER TABLE mlf2_entries CHANGE edited_by edited_by INT(11) DEFAULT NULL; INSERT INTO mlf2_settings VALUES ('forum_disabled_message', ''); UPDATE mlf2_settings SET VALUE = '2.0 beta 20' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 20 to 2.0 beta 21 */ INSERT INTO mlf2_settings VALUES ('default_email_contact', '0'); UPDATE mlf2_settings SET VALUE = '2.0 beta 21' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 21 to 2.0 beta 22 */ UPDATE mlf2_settings SET VALUE = '2.0 beta 22' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 22 to 2.0 beta 23 */ UPDATE mlf2_settings SET VALUE = '2.0 beta 23' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 23 to 2.0 beta 24 */ UPDATE mlf2_settings SET VALUE = '2.0 beta 24' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 24 to 2.0 beta 25 */ INSERT INTO mlf2_settings VALUES ('min_pw_length', '8'); UPDATE mlf2_settings SET VALUE = '2.0 beta 25' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 25 to 2.0 beta 26 */ UPDATE mlf2_settings SET VALUE = '2.0 beta 26' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 beta 26 to 2.0 RC 1 */ UPDATE mlf2_settings SET VALUE = '2.0 RC 1' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 1 to 2.0 RC 2 */ UPDATE mlf2_settings SET VALUE = '2.0 RC 2' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 2 to 2.0 RC 3 */ UPDATE mlf2_settings SET VALUE = '10' WHERE name = 'count_users_online'; UPDATE mlf2_settings SET VALUE = '2.0 RC 3' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 3 to 2.0 RC 4 */ INSERT INTO mlf2_settings VALUES ('email_subject_maxlength', '100'); INSERT INTO mlf2_settings VALUES ('email_text_maxlength', '10000'); UPDATE mlf2_settings SET VALUE = '2.0 RC 4' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 4 to 2.0 RC 5 */ INSERT INTO mlf2_settings VALUES ('forum_readonly', '0'); INSERT INTO mlf2_settings VALUES ('tags', '1'); UPDATE mlf2_settings SET VALUE = '2.0 RC 5' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 5 to 2.0 RC 6 */ UPDATE mlf2_settings SET VALUE = '2.0 RC 6' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 6 to 2.0 RC 7 */ UPDATE mlf2_settings SET VALUE = '2.0 RC 7' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 7 to 2.0 RC 8 */ UPDATE mlf2_settings SET VALUE = '2.0 RC 8' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 RC 8 to 2.0 */ UPDATE mlf2_settings SET VALUE = '2.0' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0 to 2.0.1 */ UPDATE mlf2_settings SET VALUE = '2.0.1' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0.1 to 2.0.2 */ UPDATE mlf2_settings SET VALUE = '2.0.2' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.0.* to 2.1 */ ALTER TABLE mlf2_userdata ADD category_selection VARCHAR(255) NULL DEFAULT NULL AFTER registered; ALTER TABLE mlf2_entries_cache CHANGE cache_text cache_text MEDIUMTEXT NOT NULL; INSERT INTO mlf2_settings VALUES ('timezone', ''); INSERT INTO mlf2_settings VALUES ('bbcode_flash', '0'); INSERT INTO mlf2_settings VALUES ('flash_default_width', '425'); INSERT INTO mlf2_settings VALUES ('flash_default_height', '344'); INSERT INTO mlf2_settings VALUES ('cookie_validity_days', '30'); INSERT INTO mlf2_settings VALUES ('access_permission_checks', '1'); INSERT INTO mlf2_settings VALUES ('daily_actions_time', '3:30'); INSERT INTO mlf2_settings VALUES ('next_daily_actions', '0'); INSERT INTO mlf2_settings VALUES ('auto_lock_old_threads', '0'); UPDATE mlf2_settings SET VALUE = '2.1' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.1 to 2.1.1 */ UPDATE mlf2_settings SET VALUE = '2.1.1' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.1.1 to 2.1.2 */ UPDATE mlf2_settings SET VALUE = '2.1.2' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.1.2 to 2.1.3 */ UPDATE mlf2_settings SET VALUE = '2.1.3' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.1.3 to 2.1.4 */ UPDATE mlf2_settings SET VALUE = '2.1.4' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.1.4 to 2.2 */ ALTER TABLE mlf2_userdata DROP time_difference; ALTER TABLE mlf2_userdata ADD LANGUAGE VARCHAR(255) NOT NULL DEFAULT ''; ALTER TABLE mlf2_userdata ADD time_zone VARCHAR(255) NOT NULL DEFAULT ''; ALTER TABLE mlf2_userdata ADD time_difference SMALLINT(4) DEFAULT '0'; ALTER TABLE mlf2_userdata ADD theme VARCHAR(255) NOT NULL DEFAULT ''; ALTER TABLE mlf2_userdata ADD entries_read TEXT NOT NULL; INSERT INTO mlf2_settings VALUES ('max_read_items', '200'); INSERT INTO mlf2_settings VALUES ('delete_ips', '0'); INSERT INTO mlf2_settings VALUES ('bbcode_tex', '0'); INSERT INTO mlf2_settings VALUES ('last_changes', '0'); INSERT INTO mlf2_settings VALUES ('ajax_preview', '1'); UPDATE mlf2_settings SET name = 'theme' WHERE name = 'template'; UPDATE mlf2_settings SET name = 'time_zone' WHERE name = 'timezone'; UPDATE mlf2_settings SET VALUE = '0' WHERE name = 'time_difference'; UPDATE mlf2_settings SET VALUE = '2.2' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2 to 2.2.1 */ UPDATE mlf2_settings SET VALUE = '2.2.1' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2.1 to 2.2.2 */ UPDATE mlf2_settings SET VALUE = '2.2.2' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2.2 to 2.2.3 */ UPDATE mlf2_settings SET VALUE = '2.2.3' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2.3 to 2.2.4 */ UPDATE mlf2_settings SET VALUE = '2.2.4' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2.4 to 2.2.5 */ UPDATE mlf2_settings SET VALUE = '2.2.5' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2.5 to 2.2.6 */ UPDATE mlf2_settings SET VALUE = '2.2.6' WHERE name = 'version'; /* -------------------------------------------------------------------------------- -- 2.2.6 to 2.2.7 */ UPDATE mlf2_settings SET VALUE = '2.2.7' WHERE name = 'version';
--
applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences