From owner-freebsd-ports-bugs@freebsd.org  Wed Apr  5 06:58:20 2017
Return-Path: <owner-freebsd-ports-bugs@freebsd.org>
Delivered-To: freebsd-ports-bugs@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 5BEC7D2F317
 for <freebsd-ports-bugs@mailman.ysv.freebsd.org>;
 Wed,  5 Apr 2017 06:58:20 +0000 (UTC)
 (envelope-from bugzilla-noreply@freebsd.org)
Received: from kenobi.freebsd.org (kenobi.freebsd.org
 [IPv6:2001:1900:2254:206a::16:76])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client did not present a certificate)
 by mx1.freebsd.org (Postfix) with ESMTPS id 3D328E2C
 for <freebsd-ports-bugs@FreeBSD.org>; Wed,  5 Apr 2017 06:58:20 +0000 (UTC)
 (envelope-from bugzilla-noreply@freebsd.org)
Received: from bugs.freebsd.org ([127.0.1.118])
 by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id v356wJx5046309
 for <freebsd-ports-bugs@FreeBSD.org>; Wed, 5 Apr 2017 06:58:20 GMT
 (envelope-from bugzilla-noreply@freebsd.org)
From: bugzilla-noreply@freebsd.org
To: freebsd-ports-bugs@FreeBSD.org
Subject: [Bug 218391] databases/p5-DBD-mysql: version 4.042 broke utf-8
 support of www/otrs
Date: Wed, 05 Apr 2017 06:58:19 +0000
X-Bugzilla-Reason: AssignedTo
X-Bugzilla-Type: new
X-Bugzilla-Watch-Reason: None
X-Bugzilla-Product: Ports & Packages
X-Bugzilla-Component: Individual Port(s)
X-Bugzilla-Version: Latest
X-Bugzilla-Keywords: 
X-Bugzilla-Severity: Affects Some People
X-Bugzilla-Who: topical@gmx.net
X-Bugzilla-Status: New
X-Bugzilla-Resolution: 
X-Bugzilla-Priority: ---
X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org
X-Bugzilla-Flags: 
X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform
 op_sys bug_status bug_severity priority component assigned_to reporter cc
Message-ID: <bug-218391-13@https.bugs.freebsd.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/
Auto-Submitted: auto-generated
MIME-Version: 1.0
X-BeenThere: freebsd-ports-bugs@freebsd.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: Ports bug reports <freebsd-ports-bugs.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-ports-bugs>, 
 <mailto:freebsd-ports-bugs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ports-bugs/>
List-Post: <mailto:freebsd-ports-bugs@freebsd.org>
List-Help: <mailto:freebsd-ports-bugs-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-ports-bugs>, 
 <mailto:freebsd-ports-bugs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 05 Apr 2017 06:58:20 -0000

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 the assignee for the bug.=