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:
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]
Testbuilds look fine.
Comment on attachment 181510 [details]
A commit references this bug:
Date: Thu Apr 6 02:45:05 UTC 2017
New revision: 437854
www/otrs: update 5.0.14 -> 5.0.18
- update of DBD::mysql to 4.0.42 broke otrs if using utf8
Reported by: firstname.lastname@example.org
Approved by: Mikhail Tsatsenko <email@example.com> (maintainer)