Nachdem post habe ich festgestellt das ich ein Fehler beim kopieren der neuen otrs version gemacht habe. Also war das der Versuch war mit den Daten von 4 auf 5 zu updaten was natürlich schlecht geht.
Jetzt habe ich die richtige Version (5.0.1) abgelegt doch nu kommt leider folegnder fehler:
Code: Select all
root@testotrs:/opt/otrs# cat scripts/DBUpdate-to-5.mysql.sql | mysql -p -f -u root otrs
Enter password:
ERROR 1061 (42000) at line 4: Duplicate key name 'link_relation_list_source'
ERROR 1061 (42000) at line 5: Duplicate key name 'link_relation_list_target'
ERROR 1050 (42S01) at line 9: Table 'scheduler_task' already exists
ERROR 1050 (42S01) at line 28: Table 'scheduler_future_task' already exists
ERROR 1050 (42S01) at line 47: Table 'scheduler_recurrent_task' already exists
ERROR 1091 (42000) at line 68: Can't DROP 'text2'; check that column/key exists
ERROR 1050 (42S01) at line 72: Table 'notification_event_message' already exists
ERROR 1050 (42S01) at line 87: Table 'cloud_service_config' already exists
ERROR 1022 (23000) at line 101: Can't write; duplicate key in table '#sql-28c4_3fe6'
ERROR 1022 (23000) at line 102: Can't write; duplicate key in table '#sql-28c4_3fe6'
ERROR 1022 (23000) at line 103: Can't write; duplicate key in table '#sql-28c4_3fe6'
ERROR 1022 (23000) at line 104: Can't write; duplicate key in table '#sql-28c4_3fe6'
Da die tables ja vorhanden waren bin ich einfach mal weiter gegangen jedoch DB updatescript ebenfalls fehl:
Code: Select all
$ scripts/DBUpdate-to-5.pl
Migration started...
Step 1 of 16: Refresh configuration cache...
If you see warnings about 'Subroutine Load redefined', that's fine, no need to worry!
done.
Step 2 of 16: Check framework version...done.
Step 3 of 16: Migrate Database Column Types...done.
Step 4 of 16: Migrate charset to UTF-8 on auto_response table...done.
Step 5 of 16: Migrate charset to UTF-8 on notification_event table...done.
Step 6 of 16: Migrate event based notifications to support multiple languages...done.
Step 7 of 16: Migrate notifications to event based notifications...[Thu Dec 15 10:22:44 2016] DBUpdate-to-5.pl: DBD::mysql::db do failed: Incorrect string value: '\xE7\xA5\xA8\xE6\x8D\xAE...' for column 'subject' at row 1 at /opt/otrs/Kernel/System/DB.pm line 449.
ERROR: OTRS-DBUpdate-to-5.pl-10 Perl: 5.22.1 OS: linux Time: Thu Dec 15 10:22:44 2016
Message: Incorrect string value: '\xE7\xA5\xA8\xE6\x8D\xAE...' for column 'subject' at row 1, SQL: '
INSERT INTO notification_event_message
(notification_id, subject, text, content_type, language)
VALUES (?, ?, ?, ?, ?)'
Traceback (8433):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 375
Module: main::_MigrateNotifications Line: 1207
Module: scripts/DBUpdate-to-5.pl Line: 158
error.
[Thu Dec 15 10:22:44 2016] DBUpdate-to-5.pl: Died at scripts/DBUpdate-to-5.pl line 163.
Kann ich die Fehler in der mysql DB korrigieren?