After upgrading databases/p5-DBD-mysql, otrs-5.0.14 doesn't work properly anymore. Prepared statement SQL INSERT commands seem to encode UTF-8 characters wrongly, leading to SQL errors like: "Incorrect string value: '\xE4re]' for column 'data_ key' at row 88, SQL: 'INSERT INTO sessions (session_id, data_key, data_value, se rialized) VALUES (?,?,?,?), ..." Downgrading p5-DBD-mysql to 4.041 fixes this. Digging into SVN changelog shows that UTF-8 support was kind of rewritten and I suspect that they effectively broke it at least when it comes to prepared statements.
Is this specific to FreeBSD ? if not, you should probably open a bug report on the DBD-mysql bug tracker.
Upstream ticket for DBD::mysql: https://rt.cpan.org/Ticket/Display.html?id=120953
DBD::mysql developer here. The new DBD::mysql version uncovered bugs in the OTRS usage of DBD::mysql. The OTRS bug for this is https://bugs.otrs.org/show_bug.cgi?id=12677 The fix for this is in otrs 5.0.18, so maybe it's best to update the otrs in ports as well.
Created attachment 181510 [details] patch-to-5.0.18 testbuilds@work
Testbuilds look fine.
Comment on attachment 181510 [details] patch-to-5.0.18 Approved! Thanks!
Committed, thanks!
A commit references this bug: Author: pi Date: Thu Apr 6 02:45:05 UTC 2017 New revision: 437854 URL: https://svnweb.freebsd.org/changeset/ports/437854 Log: www/otrs: update 5.0.14 -> 5.0.18 - update of DBD::mysql to 4.0.42 broke otrs if using utf8 see https://bugs.otrs.org/show_bug.cgi?id=12677 PR: 218391 Changes: https://www.otrs.com/release-notes-otrs-5s-patch-level-15/ https://www.otrs.com/release-notes-otrs-5s-patch-level-16/ https://www.otrs.com/release-notes-otrs-5s-patch-level-17/ https://www.otrs.com/release-notes-otrs-5s-patch-level-18/ Reported by: topical@gmx.net Approved by: Mikhail Tsatsenko <m.tsatsenko@gmail.com> (maintainer) Changes: head/www/otrs/Makefile head/www/otrs/distinfo head/www/otrs/pkg-plist