nach dem ich unseren neuen OTSR Server mit der Version 3.3.4 vor ein paar Wochen installiert hatte kam kurz darauf die Version 3.3.5 heraus.
Diese wollte ich heute mal flux installieren bevor ich am Wochenende die Server Mirgration durchführe.
Also bin ich die Upgrading.md durchgegangen.
1.
Code: Select all
shell> /etc/init.d/cron stop
shell> /etc/init.d/mysql stop
shell> /etc/init.d/apache2 stop
Code: Select all
- Kernel/Config.pm
- Kernel/Config/GenericAgent.pm
- Kernel/Config/Files/ZZZAuto.pm
- var/*
- as well as the database
7.
Code: Select all
shell> cd /opt/otrs/
shell> bin/otrs.SetPermissions.pl
bin/otrs.SetPermissions.pl --otrs-user=otrs --web-user=www-data --otrs-group=www-data --web-group=www-data /opt/otrs
Code: Select all
shell> /opt/otrs/bin/otrs.CheckModules.pl
Aber dann bei
9. Apply the database changes
-----------------------------
Code: Select all
shell> cd /opt/otrs/
shell> bin/otrs.CheckDB.pl
Code: Select all
root@otrs /opt/otrs # cat scripts/DBUpdate-to-3.3.mysql.sql | mysql -p -f -u root otrs
Enter password:
ERROR 1062 (23000) at line 7: Duplicate entry 'TitleUpdate' for key 'ticket_history_type_name'
ERROR 1091 (42000) at line 10: Can't DROP 'index_search_date'; check that column/key exists
ERROR 1061 (42000) at line 11: Duplicate key name 'dynamic_field_value_search_date'
ERROR 1091 (42000) at line 12: Can't DROP 'index_search_int'; check that column/key exists
ERROR 1061 (42000) at line 13: Duplicate key name 'dynamic_field_value_search_int'
ERROR 1091 (42000) at line 14: Can't DROP 'index_field_values'; check that column/key exists
ERROR 1061 (42000) at line 15: Duplicate key name 'dynamic_field_value_field_values'
ERROR 1091 (42000) at line 16: Can't DROP 'article_message_id'; check that column/key exists
ERROR 1060 (42S21) at line 20: Duplicate column name 'a_message_id_md5'
ERROR 1061 (42000) at line 21: Duplicate key name 'article_message_id_md5'
ERROR 1091 (42000) at line 22: Can't DROP 'article_search_message_id'; check that column/key exists
ERROR 1091 (42000) at line 26: Can't DROP 'a_message_id'; check that column/key exists
ERROR 1050 (42S01) at line 30: Table 'system_data' already exists
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_valid_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_queue_id_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_queue_standard_response_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_response_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_standard_attachment_id_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_create_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does not exist, skipping.
INFO: Foreign key constraint FK_standard_response_attachment_change_by_id does not exist, skipping.
ERROR 1146 (42S02) at line 109: Table 'otrs.standard_response' doesn't exist
ERROR 1146 (42S02) at line 113: Table 'otrs.standard_response' doesn't exist
ERROR 1146 (42S02) at line 117: Table 'otrs.queue_standard_response' doesn't exist
ERROR 1146 (42S02) at line 121: Table 'otrs.standard_response_attachment' doesn't exist
ERROR 1061 (42000) at line 122: Duplicate key name 'standard_template_name'
ERROR 1005 (HY000) at line 123: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1005 (HY000) at line 124: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1005 (HY000) at line 125: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1054 (42S22) at line 129: Unknown column 'standard_response_id' in 'queue_standard_template'
ERROR 1054 (42S22) at line 136: Unknown column 'standard_response_id' in 'standard_template_attachment'
ERROR 1005 (HY000) at line 140: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1005 (HY000) at line 141: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1005 (HY000) at line 142: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1005 (HY000) at line 143: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1060 (42S21) at line 147: Duplicate column name 'f_not'
ERROR 1005 (HY000) at line 152: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
ERROR 1005 (HY000) at line 153: Can't create table 'otrs.#sql-5a95_3b' (errno: 121)
root@otrs /opt/otrs #
Code: Select all
#bin/otrs.MySQLInnoDBSwitch.pl
This will change the table type of your database tables to InnoDB.
Only run this if you know what you are doing, and if there is no load on the DB server.
This operation can take lots of time.
Please type "yes" to confirm.
yes
0 tables need to be converted.
Done.
