Avatar

UPDATE von mlf 2.0beta19 zu 2.2.7 nicht hinbekommen (German / Deutsch)

by Micha ⌂, Sunday, February 06, 2011, 16:20 (4831 days ago) @ Walter

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


Complete thread:

 RSS Feed of thread