I have otrs 4 working on a CentOS 7 VM. I'm following the documentation on the upgrade process but when I run the DBUpdate-to-5.pl script it fails on step seven of 17 with this message:
I've reinstalled using two different packages, did the manual tarball install as well and still got the same error on all of them. Google results tend to indicate a field type error in the MySql db but I'm not sure how that's possible since I haven't edited the database at all.Step 7 of 17: Migrate notifications to event based notifications...[Wed Oct 12 18:58:58 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.16.3 OS: linux Time: Wed Oct 12 18:58:58 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 (23645):
Module: Kernel::System::NotificationEvent::NotificationAdd Line: 365
Module: main::_MigrateNotifications Line: 1205
Module: scripts/DBUpdate-to-5.pl Line: 162
error.
[Wed Oct 12 18:58:58 2016] DBUpdate-to-5.pl: Died at scripts/DBUpdate-to-5.pl line 167.
Thanks in advance,
Ben