Bug 218391 - www/otrs: 5.0.14 broken by databases/p5-DBD-mysql version 4.042 because of utf-8
Summary: www/otrs: 5.0.14 broken by databases/p5-DBD-mysql version 4.042 because of utf-8
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Some People
Assignee: Kurt Jaeger
Depends on:
Reported: 2017-04-05 06:58 UTC by topical
Modified: 2017-04-06 02:45 UTC (History)
4 users (show)

See Also:
pi: maintainer-feedback+

patch-to-5.0.18 (2.42 KB, patch)
2017-04-05 18:18 UTC, Kurt Jaeger
m.tsatsenko: maintainer-approval+
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description topical 2017-04-05 06:58:19 UTC
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.
Comment 1 Mathieu Arnold freebsd_committer 2017-04-05 12:11:04 UTC
Is this specific to FreeBSD ? if not, you should probably open a bug report on the DBD-mysql bug tracker.
Comment 2 Kurt Jaeger freebsd_committer 2017-04-05 12:16:43 UTC
Upstream ticket for DBD::mysql:

Comment 3 michiel.beijen 2017-04-05 17:09:59 UTC
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.
Comment 4 Kurt Jaeger freebsd_committer 2017-04-05 18:18:08 UTC
Created attachment 181510 [details]

Comment 5 Kurt Jaeger freebsd_committer 2017-04-05 18:21:12 UTC
Testbuilds look fine.
Comment 6 m.tsatsenko 2017-04-05 22:32:10 UTC
Comment on attachment 181510 [details]

Comment 7 Kurt Jaeger freebsd_committer 2017-04-06 02:45:28 UTC
Committed, thanks!
Comment 8 commit-hook freebsd_committer 2017-04-06 02:45:45 UTC
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

  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/
  Reported by:	topical@gmx.net
  Approved by:	Mikhail Tsatsenko <m.tsatsenko@gmail.com> (maintainer)