Skip Menu |
 

This queue is for tickets about the Tie-DBI CPAN distribution.

Report information
The Basics
Id: 84125
Status: resolved
Priority: 0/
Queue: Tie-DBI

People
Owner: Nobody in particular
Requestors: mechiepete [...] yahoo.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



From mechiepete [...] yahoo.com Thu Mar 21 14: 12:42 2013
MIME-Version: 1.0
X-Ymail-Osg: ZcUq0o8VM1kY8lYNNJ1UOFB1w7HjvPagTKXbYe3ZIX6afri PEmvCv3nOubEvd_JNgrGdf6xMfvrmUywlj8GFiMWQwpRUUkiQMN8DVzFUcyI UwbLJB_Q89eTJAEHGGU1wAIfsx58543S12V8WEbTtJuBNKi9pT5CTxMAUFYZ UAXrcc12v.HWXmHFC5g30ydk9RYCsXrM3RY3eWJdVW6CA7c3g6EeL01xZKBf HpYwWHnWfF8BEX0FWj.PBRl8Tf5g280vBndcKzHEY0S2YUtDvExN.SSVgi7G tNPiEwgHBXre0Ms_dJPVNcbM.Xur6fFgX.2zdFMuXO6CQHM.KhnJbBhto.Q1 f.bTGkD5TvY1sRQ8qRC0Mu6SFQ2_Z.mtlQK5kKepNYQowPs47_X81mu2p.GK 3LP_xOYaRBEKwfIdokn97Weyfe9EF8EqM874UrGjbvco3litgxLfigJFwZ2s A0s0_9zk2Ef1bnUxPnYoAF3SIdWpRcj9VDE1vlrQkUSF8482r1X9NyYy2z.Q GRypVKmKCR6JHmc.khaUqa2FHEGwceHkr3_a6E0U-
X-Spam-Status: No, score=-6.998 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Mailer: YahooMailWebService/0.8.138.524
X-Yahoo-Newman-ID: 944395.21065.bm [...] omp1001.mail.bf1.yahoo.com
X-Spam-Flag: NO
Content-Type: multipart/alternative; boundary="-1263770829-1585916182-1363889549=:3284"
Reply-To: pete w <mechiepete [...] yahoo.com>
Message-ID: <1363889549.3284.YahooMailNeo [...] web160205.mail.bf1.yahoo.com>
X-Yahoo-Newman-Property: ymail-3
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Rocket-Mimeinfo: 002.001,VGllOjpEQknCoMKgIHdpdGjCoMKgIERCRDo6bXlzcWxQUMKgIHdhcyBjcmFzaGluZyBvdXQgd2l0aCB0aGUgc2VydmVyIHNheWluZyBpdCBkaWRuJ3Qgc3VwcG9ydCBMSVNURklFTERTLgoKbXkgc2V0dXAgKGkgZG9uJ3QgdGhpbmsgaXQgaXMgc3BlY2lmaWMgdG8gYW55IG9mIHRoaXMpOgoKc3RyYXdiZXJyeSBwZXJsIDUuMTYuMyA2NC1iaXQKb24gd2luZG93cyA4IDY0LWJpdApteXNxbCBzZXJ2ZXIgdmVyc2lvbiA1LjYKbW9kdWxlcyBmcmVzaGx5IGluc3RhbGxlZCB1c2luZyBDUEFOLi4uCgpJbmRlZWQgdGgBMAEBAQE-
X-Spam-Score: -6.998
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 3EE032407B8 for <cpan-bug+tie-dbi [...] hipster.bestpractical.com>; Thu, 21 Mar 2013 14:12:42 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1Qd6AS6oJFaC for <cpan-bug+tie-dbi [...] hipster.bestpractical.com>; Thu, 21 Mar 2013 14:12:40 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 61CEB240731 for <bug-tie-dbi [...] rt.cpan.org>; Thu, 21 Mar 2013 14:12:40 -0400 (EDT)
Received: (qmail 31584 invoked by uid 103); 21 Mar 2013 18:12:39 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 21 Mar 2013 18:12:39 -0000
Received: from nm19.bullet.mail.bf1.yahoo.com (HELO nm19.bullet.mail.bf1.yahoo.com) (98.139.212.178) by 16.mx.develooper.com (qpsmtpd/0.84/v0.84-167-g4ed6cab) with SMTP; Thu, 21 Mar 2013 11:12:33 -0700
Received: from [98.139.212.152] by nm19.bullet.mail.bf1.yahoo.com with NNFMP; 21 Mar 2013 18:12:30 -0000
Received: from [98.139.212.192] by tm9.bullet.mail.bf1.yahoo.com with NNFMP; 21 Mar 2013 18:12:29 -0000
Received: from [127.0.0.1] by omp1001.mail.bf1.yahoo.com with NNFMP; 21 Mar 2013 18:12:29 -0000
Received: (qmail 25060 invoked by uid 60001); 21 Mar 2013 18:12:29 -0000
Received: from [67.249.193.122] by web160205.mail.bf1.yahoo.com via HTTP; Thu, 21 Mar 2013 11:12:29 PDT
Authentication-Results: hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] yahoo.com
Authentication-Results: hipster.bestpractical.com (amavisd-new); domainkeys=pass header.from=mechiepete [...] yahoo.com
Delivered-To: cpan-bug+tie-dbi [...] hipster.bestpractical.com
Subject: Tie::DBI vs DBD::mysqlPP, sql LISTFIELDS bug (and fix)
Domainkey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=6I/e4aqgoGf83vgwGlxJyLPE8koSagXvOYikc++I1nH0eehwYg+bDMSI3CED1G2oBSe2LvfPquBrWpGrpCOt+SpKTNEsgPAp23LROhyMaCny4SIZlPkfZmHAw8O1HQ1IJdoYpxFkmNR/DKQgWwPpriqpzv73R7wprW1gnjxs3pc=;
Return-Path: <mechiepete [...] yahoo.com>
X-RT-Mail-Extension: tie-dbi
X-Original-To: cpan-bug+tie-dbi [...] hipster.bestpractical.com
X-Spam-Check-BY: 16.mx.develooper.com
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1363889549; bh=yLN3uN+Ud+uwG5FFhiG2654na+ZW4nC0bFcqVG52ARI=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=ndwJEoeDjHNHH0N0fcUU2f7TW0UoGnxnJV7h8aKnpFSptL3f71eaJacRcNV6rjfyn730EwvbbFWhp76gpkk05oVm6tDs61ohQuGo4uG+uknYboKCO4zzsdNCmKCgP3JFyAYfpWJvAMGkGHsD8drwKpKPymgXFrgLCLhEP3UwZ1o=
Date: Thu, 21 Mar 2013 11:12:29 -0700 (PDT)
X-Spam-Level:
To: "bug-Tie-DBI [...] rt.cpan.org" <bug-Tie-DBI [...] rt.cpan.org>
From: pete w <mechiepete [...] yahoo.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: iso-8859-1
Content-Length: 1005
Download (untitled) / with headers
text/plain 1005b
Tie::DBI   with   DBD::mysqlPP  was crashing out with the server saying it didn't support LISTFIELDS. my setup (i don't think it is specific to any of this): strawberry perl 5.16.3 64-bit on windows 8 64-bit mysql server version 5.6 modules freshly installed using CPAN... Indeed the DBD::mysqlPP documentation says you cannot use LISTFIELDS. DBI.pm already has a workaround for this but it was not activated for mysqlPP. I was able to update the following file: .../perl/site/lib/Tie/DBI.pm   around  line 38 : my %CANNOT_LISTFIELDS = (              'SQLite' => 1,              'Oracle' => 1,              'mysqlPP' => 1             ########  added this to fix problem             ); Would appreciate if you added this? Thanks, let me know /  feel free to contact me -Pete Weisz PS- is there a way to change the %CANNOTLISTFIELDS from the code "use"ing Tie::DBI? PPS- Many, many thanks for maintaining these awesomely useful tools!
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: iso-8859-1
Content-Length: 2921
MIME-Version: 1.0
In-Reply-To: <1363889549.3284.YahooMailNeo [...] web160205.mail.bf1.yahoo.com>
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
References: <1363889549.3284.YahooMailNeo [...] web160205.mail.bf1.yahoo.com>
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-8516-1364447167-1920.84125-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 137
Download (untitled) / with headers
text/plain 137b
I've added your change to the next release via github: https://github.com/toddr/Tie-DBI/commit/3cf9edf7a305b9f6dff3749b1b479a23a8b74c02


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.