Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 05 Apr 2017 06:58:19 +0000
From:      bugzilla-noreply@freebsd.org
To:        perl@FreeBSD.org
Subject:   [Bug 218391] databases/p5-DBD-mysql: version 4.042 broke utf-8 support of www/otrs
Message-ID:  <bug-218391-14331@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D218391

            Bug ID: 218391
           Summary: databases/p5-DBD-mysql: version 4.042 broke utf-8
                    support of www/otrs
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs@FreeBSD.org
          Reporter: topical@gmx.net
                CC: m.tsatsenko@gmail.com, perl@FreeBSD.org
                CC: m.tsatsenko@gmail.com, perl@FreeBSD.org

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 charac=
ters
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_valu=
e,
se
rialized) VALUES (?,?,?,?), ..."

Downgrading p5-DBD-mysql to 4.041 fixes this. Digging into SVN changelog sh=
ows
that UTF-8 support was kind of rewritten and I suspect that they effectively
broke it at least when it comes to prepared statements.

--=20
You are receiving this mail because:
You are on the CC list for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-218391-14331>