Incorrect string value for column 'subject' row 1

[bendegreat]

Hi,

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:

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.

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.

Thanks in advance,
Ben

[lymac]

Hi,

we get the same error.
I have tried before upgrade to otrs5, do an update to otrs4 with the latest patchlevel, but still the same error.

Maybe, do you solve this problem?

best regards
lymac

[lymac]

Hi,

I solved the problem.
After I updated the database and the tables to utf8mb4, I could successfully run the databaseupdate.

best regards
lymac

[vai0l0]

Did you upgrade just the notification_event_message table or the whole DB?

do you have a script to upgrade to utf8mb4 ?