bei dem Update von OTRS 4 nach 5 gibt es bei dem DBUpdate einen Fehler:
als user otrs ausgeführt.
scripts/DBUpdate-to-5.pl
DB ist Innodb
caracterset ist UTF8
Code: Select all
Step 7 of 16: Migrate notifications to event based notifications...[Tue Nov 21 11:43:42 2017] 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.16.3 OS: linux Time: Tue Nov 21 11:43:42 2017
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 (15985):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 365
Module: main::_MigrateNotifications Line: 1201
Module: scripts/DBUpdate-to-5.pl Line: 158
error.
[Tue Nov 21 11:43:42 2017] DBUpdate-to-5.pl: Died at scripts/DBUpdate-to-5.pl line 163.
Gruß, Tom.