ich wollte am WE einen Update meines Forums von 3.1.x auf 3.2.4 durchführen. Ich bin dabei vorgegangen entsprechend der Anleitung
community/KB/phpBB 3.2 - Upgade von phpBB 3.1.x auf 3.2.x und habe dort den manuellen Update gewählt.
Ich habe dort Schritt für Schritt abgehakt. Ich konnte mich dann als 'admin' anmelden (das BB war ja gesperrt), sah aber gleich diese Fehlermeldung:
Dort wurd ich dann zum Datenbankupdate geführt, der dann leider schiefgelaufen ist.Deine phpBB-Installation wurde nicht vollständig aktualisiert. Bitte lies die folgenden Information, um diesen Fehler zu beheben.
Der Update blieb bei 84% hängen und folgende Fehlermeldung wurde angezeigt.
Code: Alles auswählen
General Error:SQL ERROR [ mysqli ]Duplicate key name 'itm_usr_mthd'
[1061]SQLALTER TABLE phpBB_user_notifications ADD INDEX itm_usr_mthd (item_type, item_id, user_id, method) in file /customers/b/a/b/xxxxxxxxxx.de/httpd.www/phpbb/db/driver/driver.php on line 997BACKTRACEFILE: (not given by php)LINE: (not given by php)CALL: installer_msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 997CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/mysqli.phpLINE: 193CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1064CALL: phpbb\db\driver\mysqli->sql_query()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1551CALL: phpbb\db\tools\tools->_sql_run_sql()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 671CALL: phpbb\db\tools\tools->sql_create_index()FILE: (not given by php)LINE: (not given by php)CALL: phpbb\db\tools\tools->perform_schema_changes()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 714CALL: call_user_func_array()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 661CALL: phpbb\db\migrator->run_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 400CALL: phpbb\db\migrator->process_data_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 288CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 241CALL: phpbb\db\migrator->update_do()FILE: [ROOT]/phpbb/install/module/update_database/task/update.phpLINE: 160CALL: phpbb\db\migrator->update()FILE: [ROOT]/phpbb/install/module_base.phpLINE: 149CALL: phpbb\install\module\update_database\task\update->run()FILE: [ROOT]/phpbb/install/installer.phpLINE: 219CALL: phpbb\install\module_base->run()FILE: [ROOT]/phpbb/install/controller/update.phpLINE: 133CALL: phpbb\install\installer->run()FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.phpLINE: 111CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()FILE: [ROOT]/vendor/symfony/http-foundation/Response.phpLINE: 383CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()FILE: [ROOT]/install/app.phpLINE: 62CALL: Symfony\Component\HttpFoundation\Response->send()
Installing Schema: \phpbb\db\migration\data\v32x\user_notifications_table_temp_index.
Installed Data: \phpbb\db\migration\data\v32x\user_notifications_table_reduce_column_sizes; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v32x\user_notifications_table_reduce_column_sizes.
Installed Schema: \phpbb\db\migration\data\v32x\user_notifications_table_reduce_column_sizes; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v32x\user_notifications_table_reduce_column_sizes.
Installed Data: \phpbb\db\migration\data\v32x\user_notifications_table_index_p3; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v32x\user_notifications_table_index_p3.
Installed Schema: \phpbb\db\migration\data\v32x\user_notifications_table_index_p3; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v32x\user_notifications_table_index_p3.
Installed Data: \phpbb\db\migration\data\v32x\user_notifications_table_index_p2; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v32x\user_notifications_table_index_p2.
Installed Schema: \phpbb\db\migration\data\v32x\user_notifications_table_index_p2; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v32x\user_notifications_table_index_p2.
Installed Data: \phpbb\db\migration\data\v32x\user_notifications_table_index_p1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v32x\user_notifications_table_index_p1.
Installed Schema: \phpbb\db\migration\data\v32x\user_notifications_table_index_p1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v32x\user_notifications_table_index_p1.
Migration already effectively installed (skipped): \phpbb\db\migration\data\v32x\cookie_notice_p2
Installed Data: \phpbb\db\migration\data\v32x\load_user_activity_limit; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v32x\load_user_activity_limit.
Installed Schema: \phpbb\db\migration\data\v32x\load_user_activity_limit; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v32x\load_user_activity_limit.
Installed Data: \phpbb\db\migration\data\v320\v320; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320.
Installed Schema: \phpbb\db\migration\data\v320\v320; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320.
Installed Data: \phpbb\db\migration\data\v320\cookie_notice; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\cookie_notice.
Installed Schema: \phpbb\db\migration\data\v320\cookie_notice; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\cookie_notice.
Installed Data: \phpbb\db\migration\data\v320\v320rc2; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320rc2.
Installed Schema: \phpbb\db\migration\data\v320\v320rc2; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320rc2.
Installed Data: \phpbb\db\migration\data\v320\add_help_phpbb; Time: 0.02 seconds
Installing Data: \phpbb\db\migration\data\v320\add_help_phpbb.
Installed Schema: \phpbb\db\migration\data\v320\add_help_phpbb; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\add_help_phpbb.
Installed Data: \phpbb\db\migration\data\v320\v320rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320rc1.
Installed Schema: \phpbb\db\migration\data\v320\v320rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320rc1.
Installed Data: \phpbb\db\migration\data\v320\v320b2; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320b2.
Installed Schema: \phpbb\db\migration\data\v320\v320b2; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320b2.
Installed Data: \phpbb\db\migration\data\v320\remote_upload_validation; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\remote_upload_validation.
Installed Schema: \phpbb\db\migration\data\v320\remote_upload_validation; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\remote_upload_validation.
Installed Data: \phpbb\db\migration\data\v320\v320b1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320b1.
Installed Schema: \phpbb\db\migration\data\v320\v320b1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320b1.
Installed Data: \phpbb\db\migration\data\v320\report_id_auto_increment; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\report_id_auto_increment.
Installed Schema: \phpbb\db\migration\data\v320\report_id_auto_increment; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v320\report_id_auto_increment.
Installed Data: \phpbb\db\migration\data\v320\default_data_type_ids; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\default_data_type_ids.
Installed Schema: \phpbb\db\migration\data\v320\default_data_type_ids; Time: 5.99 seconds
Installing Schema: \phpbb\db\migration\data\v320\default_data_type_ids.
Migration already effectively installed (skipped): \phpbb\db\migration\data\v320\oauth_states
Installed Data: \phpbb\db\migration\data\v320\v320a2; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320a2.
Installed Schema: \phpbb\db\migration\data\v320\v320a2; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320a2.
Installed Data: \phpbb\db\migration\data\v320\v320a1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\v320a1.
Installed Schema: \phpbb\db\migration\data\v320\v320a1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\v320a1.
Installed Data: \phpbb\db\migration\data\v320\notifications_board; Time: 0.01 seconds
Installing Data: \phpbb\db\migration\data\v320\notifications_board.
Installed Schema: \phpbb\db\migration\data\v320\notifications_board; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\notifications_board.
Installed Data: \phpbb\db\migration\data\v320\remove_outdated_media; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\remove_outdated_media.
Installed Schema: \phpbb\db\migration\data\v320\remove_outdated_media; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\remove_outdated_media.
Installed Data: \phpbb\db\migration\data\v320\log_post_id; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\log_post_id.
Installed Schema: \phpbb\db\migration\data\v320\log_post_id; Time: 0.03 seconds
Installing Schema: \phpbb\db\migration\data\v320\log_post_id.
Installed Data: \phpbb\db\migration\data\v320\icons_alt; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\icons_alt.
Installed Schema: \phpbb\db\migration\data\v320\icons_alt; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v320\icons_alt.
Installed Data: \phpbb\db\migration\data\v320\font_awesome_update; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\font_awesome_update.
Installed Schema: \phpbb\db\migration\data\v320\font_awesome_update; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\font_awesome_update.
Installed Data: \phpbb\db\migration\data\v320\remove_profilefield_wlm; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\remove_profilefield_wlm.
Installed Schema: \phpbb\db\migration\data\v320\remove_profilefield_wlm; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v320\remove_profilefield_wlm.
Installed Data: \phpbb\db\migration\data\v320\announce_global_permission; Time: 0.02 seconds
Installing Data: \phpbb\db\migration\data\v320\announce_global_permission.
Installed Schema: \phpbb\db\migration\data\v320\announce_global_permission; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\announce_global_permission.
Installed Data: \phpbb\db\migration\data\v320\text_reparser; Time: 0.57 seconds
Installing Data: \phpbb\db\migration\data\v320\text_reparser.
Installed Schema: \phpbb\db\migration\data\v320\text_reparser; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\text_reparser.
Installed Data: \phpbb\db\migration\data\v320\allowed_schemes_links; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\allowed_schemes_links.
Installed Schema: \phpbb\db\migration\data\v320\allowed_schemes_links; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\allowed_schemes_links.
Installed Data: \phpbb\db\migration\data\v320\dev; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v320\dev.
Installed Schema: \phpbb\db\migration\data\v320\dev; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v320\dev.
Installed Data: \phpbb\db\migration\data\v31x\v3112; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v3112.
Installed Schema: \phpbb\db\migration\data\v31x\v3112; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v3112.
Installed Data: \phpbb\db\migration\data\v31x\v3111; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v3111.
Installed Schema: \phpbb\db\migration\data\v31x\v3111; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v3111.
Installed Data: \phpbb\db\migration\data\v31x\v3111rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v3111rc1.
Installed Schema: \phpbb\db\migration\data\v31x\v3111rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v3111rc1.
Installed Data: \phpbb\db\migration\data\v31x\add_latest_topics_index; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\add_latest_topics_index.
Installed Schema: \phpbb\db\migration\data\v31x\add_latest_topics_index; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\add_latest_topics_index.
Installed Data: \phpbb\db\migration\data\v31x\remove_duplicate_migrations; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\remove_duplicate_migrations.
Installed Schema: \phpbb\db\migration\data\v31x\remove_duplicate_migrations; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\remove_duplicate_migrations.
Installed Data: \phpbb\db\migration\data\v31x\update_hashes; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\update_hashes.
Installed Schema: \phpbb\db\migration\data\v31x\update_hashes; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\update_hashes.
Installed Data: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options.
Installed Schema: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\add_smtp_ssl_context_config_options.
Installed Data: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options.
Installed Schema: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\add_jabber_ssl_context_config_options.
Installed Data: \phpbb\db\migration\data\v31x\increase_size_of_emotion; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\increase_size_of_emotion.
Installed Schema: \phpbb\db\migration\data\v31x\increase_size_of_emotion; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\increase_size_of_emotion.
Installed Data: \phpbb\db\migration\data\v31x\add_log_time_index; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\add_log_time_index.
Installed Schema: \phpbb\db\migration\data\v31x\add_log_time_index; Time: 0.03 seconds
Installing Schema: \phpbb\db\migration\data\v31x\add_log_time_index.
Installed Data: \phpbb\db\migration\data\v31x\v3110; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v3110.
Installed Schema: \phpbb\db\migration\data\v31x\v3110; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v3110.
Installed Data: \phpbb\db\migration\data\v31x\v3110rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v3110rc1.
Installed Schema: \phpbb\db\migration\data\v31x\v3110rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v3110rc1.
Installed Data: \phpbb\db\migration\data\v31x\v319; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v319.
Installed Schema: \phpbb\db\migration\data\v31x\v319; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v319.
Installed Data: \phpbb\db\migration\data\v31x\v319rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v319rc1.
Installed Schema: \phpbb\db\migration\data\v31x\v319rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v319rc1.
Installed Data: \phpbb\db\migration\data\v31x\v318; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v318.
Installed Schema: \phpbb\db\migration\data\v31x\v318; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v318.
Installed Data: \phpbb\db\migration\data\v31x\v318rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v318rc1.
Installed Schema: \phpbb\db\migration\data\v31x\v318rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v318rc1.
Installed Data: \phpbb\db\migration\data\v31x\v317pl1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v317pl1.
Installed Schema: \phpbb\db\migration\data\v31x\v317pl1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v317pl1.
Installed Data: \phpbb\db\migration\data\v31x\increase_size_of_dateformat; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\increase_size_of_dateformat.
Installed Schema: \phpbb\db\migration\data\v31x\increase_size_of_dateformat; Time: 0.01 seconds
Installing Schema: \phpbb\db\migration\data\v31x\increase_size_of_dateformat.
Installed Data: \phpbb\db\migration\data\v31x\v317; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v317.
Installed Schema: \phpbb\db\migration\data\v31x\v317; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v317.
Installed Data: \phpbb\db\migration\data\v31x\v317rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v317rc1.
Installed Schema: \phpbb\db\migration\data\v31x\v317rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v317rc1.
Installed Data: \phpbb\db\migration\data\v31x\v316; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v316.
Installed Schema: \phpbb\db\migration\data\v31x\v316; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v316.
Installed Data: \phpbb\db\migration\data\v31x\m_pm_report; Time: 0.07 seconds
Installing Data: \phpbb\db\migration\data\v31x\m_pm_report.
Installed Schema: \phpbb\db\migration\data\v31x\m_pm_report; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\m_pm_report.
Installed Data: \phpbb\db\migration\data\v31x\v316rc1; Time: 0.00 seconds
Installing Data: \phpbb\db\migration\data\v31x\v316rc1.
Installed Schema: \phpbb\db\migration\data\v31x\v316rc1; Time: 0.00 seconds
Installing Schema: \phpbb\db\migration\data\v31x\v316rc1.
Skip “installer.update_filesystem.download_updated_files” task
Skip “installer.update_filesystem.update_files” task
Skip “installer.update_filesystem.show_file_status” task
Skip “installer.update_filesystem.diff_files” task
Skip “installer.update_filesystem.check_task” task
Skip “installer.obtain_data.update_ftp_settings” task
Skip “installer.obtain_data.update_files” task
Skip “installer.obtain_data.file_updater_method” task
Wer kann mir da helfen.
Vielebn Dank