Probleme beim Update auf 2.0.6

[IcedEarthAngel]

Hi, bisher hat ja alles immer ganz gut geklappt. Aber vom Update von 2.0.5 auf 2.0.6 nicht mehr so sehr...

Nachdem ich alle Dateien auf dem Server ersetzt habe, führe ich noch die update_to_206.php aus. Leider mit vielen Fehlermeldungen behaftet...

--------------------------------------------------------------------------------------
Progress :: . . . . . . . . . . . . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Can't DROP 'user_autologin_key'. Check that column/key exists
SQL :: ALTER TABLE phpbb_users DROP COLUMN user_autologin_key


Error :: Can't DROP 'rank_max'. Check that column/key exists
SQL :: ALTER TABLE phpbb_ranks DROP COLUMN rank_max


Error :: Duplicate column name 'user_session_time'
SQL :: ALTER TABLE phpbb_users ADD COLUMN user_session_time int(11) DEFAULT '0' NOT NULL, ADD COLUMN user_session_page smallint(5) DEFAULT '0' NOT NULL, ADD INDEX (user_session_time)


Error :: Duplicate column name 'topic_first_post_id'
SQL :: ALTER TABLE phpbb_topics MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ADD COLUMN topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ADD INDEX (topic_first_post_id)


Error :: Duplicate column name 'tr_class1_name'
SQL :: ALTER TABLE phpbb_themes_name ADD COLUMN tr_class1_name varchar(50) NULL, ADD COLUMN tr_class2_name varchar(50) NULL, ADD COLUMN tr_class3_name varchar(50) NULL, ADD COLUMN th_class1_name varchar(50) NULL, ADD COLUMN th_class2_name varchar(50) NULL, ADD COLUMN th_class3_name varchar(50) NULL, ADD COLUMN td_class1_name varchar(50) NULL, ADD COLUMN td_class2_name varchar(50) NULL, ADD COLUMN td_class3_name varchar(50) NULL, ADD COLUMN span_class1_name varchar(50) NULL, ADD COLUMN span_class2_name varchar(50) NULL, ADD COLUMN span_class3_name varchar(50) NULL


Error :: Duplicate key name 'post_id'
SQL :: ALTER TABLE phpbb_search_wordmatch ADD INDEX post_id (post_id)


Error :: Table 'phpbb_confirm' already exists
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))
--------------------------------------------------------------------------------------

Was kann ich tun?

Will ich ins Forum kommt folgende Meldung:
Warning: file_exists() [function.file-exists]: Unable to access in ***/forum/includes/functions.php on line 238
message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

Schonmal Danke für eure Hilfe!
Iced

[jasc]

Habe ich dich richtig verstanden, dass du einfach die veränderten Dateien ersetzt hast (also kein manuelles Update)?
Hattest du Mods eingebaut?
Ansonsten, ich hoffe, du hast vorher ein Backup gemacht .

[IcedEarthAngel]

Was versteht du unter manuelles Update?

Ich hatte die Version 2.0.5 installiert. Ich hab mir die Update Packages heruntergeladen und anschliessend die Dateien aus der Zipfile : "2.0.5_to_2.0.6.zip" auf den Server geschrieben und die vorhandenen Dateien ersetzt. Nach Anleitung!

--------------------------------------------------------------------------------------

This package contains a number of archives, each contains the files changed from a given release to 2.0.6. You should select the appropriate archive for your current version, e.g. if you currently have 2.0.5 you should select the phpBB-2.0.5_to_2.0.6.zip/tar.gz file.

The directory structure has been preserved enabling you (if you wish) to simply upload the contents of the archive to the appropriate location on your server, i.e. simply overwrite the existing files with the new versions. Do not forget that if you have installed any Mods these files will overwrite the originals possibly destroying them in the process. You will need to re-add Mods to any affected file before uploading.

As for the other upgrade procedures you should run install/update_to_206.php after you have finished updating the files. This will update your database schema and data (if appropriate) and increment the version number.

--------------------------------------------------------------------------------------

Danach Update ausgeführt und jetzt steh ich da...

[MiXa]

manuelles update

hierbei würdest du selber die veränderten codezeilen austauschen - und nur diese

also quasi wie bei einem modeinbau

[Acid]

Für mich sehen die Fehlermeldungen eher so aus, als wäre das Updatescript bereits schon erfolgreich durchgelaufen (und beim zweiten Durchlauf wird versucht, Sachen zu löschen/ändern, die bereits gelöscht/geändert wurden).

Warning: file_exists() [function.file-exists]: Unable to access in ***/forum/includes/functions.php on line 238
message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

Darauf achten, das a) der Ordner /install nach dem Update gelöscht wurde, b) der Ordner subSilver (bzw. dein_template) korrekt geschrieben ist (Grossschreibung beachten) und c) das sich im /images Ordner des Templates noch ein Unterordner mit dem/den Namen des/der genutzten Sprache(n) befindet (auch wenn diese leer sind).

[IcedEarthAngel]

@ Acid: Alles kontrolliert:

Stimmt alles. Den Install Ordner lösche ich auch immer!

[IcedEarthAngel]

Hier die komplette Ansage von update_to_206.php

--------------------------------------------------------------------------------------

Updated version :: 2.0.6

Updating database schema
Progress :: . . . . . . . . . . . . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Can't DROP 'user_autologin_key'. Check that column/key exists
SQL :: ALTER TABLE phpbb_users DROP COLUMN user_autologin_key


Error :: Can't DROP 'rank_max'. Check that column/key exists
SQL :: ALTER TABLE phpbb_ranks DROP COLUMN rank_max


Error :: Duplicate column name 'user_session_time'
SQL :: ALTER TABLE phpbb_users ADD COLUMN user_session_time int(11) DEFAULT '0' NOT NULL, ADD COLUMN user_session_page smallint(5) DEFAULT '0' NOT NULL, ADD INDEX (user_session_time)


Error :: Duplicate column name 'topic_first_post_id'
SQL :: ALTER TABLE phpbb_topics MODIFY topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ADD COLUMN topic_first_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, ADD INDEX (topic_first_post_id)


Error :: Duplicate column name 'tr_class1_name'
SQL :: ALTER TABLE phpbb_themes_name ADD COLUMN tr_class1_name varchar(50) NULL, ADD COLUMN tr_class2_name varchar(50) NULL, ADD COLUMN tr_class3_name varchar(50) NULL, ADD COLUMN th_class1_name varchar(50) NULL, ADD COLUMN th_class2_name varchar(50) NULL, ADD COLUMN th_class3_name varchar(50) NULL, ADD COLUMN td_class1_name varchar(50) NULL, ADD COLUMN td_class2_name varchar(50) NULL, ADD COLUMN td_class3_name varchar(50) NULL, ADD COLUMN span_class1_name varchar(50) NULL, ADD COLUMN span_class2_name varchar(50) NULL, ADD COLUMN span_class3_name varchar(50) NULL


Error :: Duplicate key name 'post_id'
SQL :: ALTER TABLE phpbb_search_wordmatch ADD INDEX post_id (post_id)


Error :: Table 'phpbb_confirm' already exists
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))


This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our development board. See README for details on how to obtain advice.

Updating data
Progress :: . . . . . . . . . . . . . . . . . .

Updating version and optimizing tables
Progress :: . . Done
Result :: Some queries failed, the statements and errors are listing below

Error :: Duplicate entry 'server_name' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld')


Error :: Duplicate entry 'script_path' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/')


Error :: Duplicate entry 'server_port' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80')


Error :: Duplicate entry 'record_online_users' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '1')


Error :: Duplicate entry 'record_online_date' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '1065958537')


Error :: Duplicate entry 'enable_confirm' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0')


Error :: Duplicate entry 'sendmail_fix' for key 1
SQL :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('sendmail_fix', '0')


This is probably nothing to worry about, update will continue. Should this fail to complete you may need to seek help at our development board. See README for details on how to obtain advice.

[jasc]

Hattest du Mods eingebaut?
Ansonsten, ich hoffe, du hast vorher ein Backup gemacht .

[Gast]

Hatte kein Backup...

Habs jetzt schnell neuinstalliert. Hat gut geklappt. Nur ein Problem bei den Private Messages.

Habe eine erhalten, klicke ich sie an erschein im Feld folgende Meldung:

Could not find oldest privmsgs

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AND privmsgs_from_userid = 2' at line 4

SELECT privmsgs_id FROM phpbb_privmsgs WHERE privmsgs_type = 2 AND privmsgs_date = AND privmsgs_from_userid = 2

Line : 314
File : /home/www/web116/html/protected/forum/privmsg.php

Hab ich irgendetwas flasch konfiguriert?

Iced