Skip Menu |
 

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

Report information
The Basics
Id: 118491
Status: open
Priority: 0/
Queue: Class-DBI

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

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



MIME-Version: 1.0
X-Spam-Status: No, score=-1.899 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=ham
X-Spam-Flag: NO
X-Virus-Checked: Checked
X-He-Tag: mask47_8277d0ade8029
Content-Type: multipart/alternative; boundary="------------6D0737CA19960CBA4D530E36"
Message-ID: <050a7932-19d0-5179-2847-0bac76ba1314 [...] chintzbaby.com>
Reply-To: chintzbaby [...] chintzbaby.com
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Organization: ChintzBaby
X-Spam-Score: -1.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 1577E2401A5 for <cpan-bug+class-dbi [...] hipster.bestpractical.com>; Mon, 24 Oct 2016 12:51:51 -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 4ICO5DafXFxg for <cpan-bug+class-dbi [...] hipster.bestpractical.com>; Mon, 24 Oct 2016 12:51:49 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id D58E724007A for <bug-class-dbi [...] rt.cpan.org>; Mon, 24 Oct 2016 12:51:48 -0400 (EDT)
Received: (qmail 31571 invoked by alias); 24 Oct 2016 16:51:47 -0000
Received: from smtprelay0251.hostedemail.com (HELO smtprelay.hostedemail.com) (216.40.44.251) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 24 Oct 2016 09:51:41 -0700
Received: from filter.hostedemail.com (clb03-v110.bra.tucows.net [216.40.38.60]) by smtprelay07.hostedemail.com (Postfix) with ESMTP id 46729C211F for <bug-class-dbi [...] rt.cpan.org>; Mon, 24 Oct 2016 16:51:37 +0000 (UTC)
Received: from [192.168.0.4] (18.126.112.87.dyn.plus.net [87.112.126.18]) (Authenticated sender: andyc [...] andycragg.com) by omf13.hostedemail.com (Postfix) with ESMTPA for <bug-Class-DBI [...] rt.cpan.org>; Mon, 24 Oct 2016 16:51:36 +0000 (UTC)
Delivered-To: cpan-bug+class-dbi [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.3.0
Subject: Ubuntu 16.04, MySQL 5.7, "Can't get last insert id" error on inserting row.
Return-Path: <chintzbaby [...] chintzbaby.com>
X-RT-Mail-Extension: class-dbi
X-Original-To: cpan-bug+class-dbi [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Mon, 24 Oct 2016 17:51:25 +0100
X-Spam-Level:
X-Session-Marker: 616E64796340616E647963726167672E636F6D
X-Filterd-Recvd-Size: 8750
To: bug-Class-DBI [...] rt.cpan.org
From: ChintzBaby <chintzbaby [...] chintzbaby.com>
X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,chintzbaby [...] chintzbaby.com,:,RULES_HIT:41:72:152:355:379:854:960:962:966:967:973:983:988:989:1189:1208:1212:1221:1260:1261:1313:1314:1345:1381:1431:1436:1437:1516:1517:1518:1535:1544:1575:1588:1589:1592:1594:1685:1711:1730:1776:1792:2068:2069:2196:2198:2199:2200:2525:2553:2561:2564:2682:2685:2859:2902:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3354:3653:3834:3865:3867:3868:3870:3871:3872:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4119:4184:4250:4362:4385:4560:4605:5007:6119:7652:7875:7903:7904:7974:8784:8957:9025:9040:9121:10004:10848:11026:11233:11657:11658:11783:11889:11914:12043:12296:12438:12555:12660:12663:12679:12698:12737:12740:13019:13160:13161:13180:13229:13991:14093:14149:14180:14181:14659:14721:14885:21060:21080:21222:21324:21325:21433:21451:30054:30070:30080:30090:30091,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:fn,MSBL:0,DNSBL:none,Custom_rules:0:0:0,L
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"; format="flowed"
Content-Transfer-Encoding: 7bit
X-RT-Original-Encoding: utf-8
Content-Length: 3083
Hi, * Class-DBI-v3.0.17 * Perl : v5.22.1 * Ubuntu 16.04 : Linux 4.4.0-45-lowlatency #66-Ubuntu SMP PREEMPT Wed Oct 19 14:57:51 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux * MySQL : Ver 14.14 Distrib 5.7.15, for Linux (x86_64) * DBD-mysql-4.038 * libmysqlclient.so.20.3.2 I've upgraded Ubuntu from 15.10 (MySQL5.6) and now have MySQL 5.7, and I get "Can't get last insert id" when inserting a row into a table, where in 5.6/15.10 it worked fine. The row does get inserted into the table ok, but the inserted row_id is not returned by MySQL : Line 609 in /usr/local/share/perl/5.22.1/Class/DBI.pm : sub _auto_increment_value { ... my $id = $dbh->last_insert_id(undef, undef, $self->table, undef) # std || $dbh->{mysql_insertid} # mysql || eval { $dbh->func('last_insert_rowid') } *or $self->_croak("Can't get last insert id");* Called from my CGI program : use DBI; use MyApp; use MyApp::PictureTag; ... MyApp::PictureTag->insert ( { Picture_id => $PicId, Tag_id => $TagId, } ); PictureTag has a primary auto-increment key. DBI Trace : -> ping for DBD::mysql::db (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30)~0x55b68bc45e68) thr#55b68a5a8220 T <- ping= ( 1 ) [1 items] at /usr/local/share/perl/5.22.1/Ima/DBI.pm line 326 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 600 Show quoted text
>> last_insert_id DISPATCH
(DBIx::ContextualFetch::db=HASH(0x55b68bc45d30) rc1/3 @5 g2 ima2801 pid#13281) at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 628 -> last_insert_id for DBD::mysql::db (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30)~0x55b68bc45e68 undef undef 'PictureTag' undef) thr#55b68a5a8220 T <- last_insert_id= ( '0' ) [1 items] at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 628 Show quoted text
>> FETCH DISPATCH
(DBIx::ContextualFetch::db=HASH(0x55b68bc45e68) rc2/23 @2 g2 ima404 pid#13281) at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 628 -> FETCH for DBD::mysql::db (DBIx::ContextualFetch::db=HASH(0x55b68bc45e68)~INNER 'mysql_insertid') thr#55b68a5a8220 T <- FETCH= ( '0' ) [1 items] at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 628 Show quoted text
>> func DISPATCH
(DBIx::ContextualFetch::db=HASH(0x55b68bc45d30) rc1/3 @2 g2 ima6 pid#13281) at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 -> last_insert_rowid for DBD::mysql::db (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30)~0x55b68bc45e68) thr#55b68a5a8220 I've seen some reference to this here : https://rt.cpan.org/Public/Bug/Display.html?id=108000 and in the change notes for 4.035_01, but I do not know how to solve this issue (apart from going back to MySQL 5.6). I've scrubbed Google and I can't find anyone else who has had this issue! Thanks much for any help. Andy
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: 8bit
X-RT-Original-Encoding: utf-8
Content-Length: 4364
MIME-Version: 1.0
X-Spam-Status: No, score=-3.899 tagged_above=-99.9 required=10 tests=[AWL=2.000, BAYES_00=-1.9, FROM_OUR_RT=-4, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001] autolearn=ham
In-Reply-To: <rt-4.0.18-11300-1477327912-1517.118491-3-0 [...] rt.cpan.org>
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-118491 [...] rt.cpan.org> <050a7932-19d0-5179-2847-0bac76ba1314 [...] chintzbaby.com> <rt-4.0.18-11300-1477327912-1517.118491-3-0 [...] rt.cpan.org>
X-Virus-Checked: Checked
X-He-Tag: joke30_c0221cbc6738
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Reply-To: chintzbaby [...] chintzbaby.com
Message-ID: <9542c0e0-3706-8580-7a22-33094e801b1b [...] chintzbaby.com>
Content-Type: multipart/alternative; boundary="------------BA7D18F2345F793DBA6EBF0F"
Organization: ChintzBaby
X-Spam-Score: -3.899
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 93B68240312 for <cpan-bug+class-dbi [...] hipster.bestpractical.com>; Wed, 26 Oct 2016 08:14:58 -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 qrZDhBHx502b for <cpan-bug+class-dbi [...] hipster.bestpractical.com>; Wed, 26 Oct 2016 08:14:54 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 32D3D240039 for <bug-class-dbi [...] rt.cpan.org>; Wed, 26 Oct 2016 08:14:54 -0400 (EDT)
Received: (qmail 907 invoked by alias); 26 Oct 2016 12:14:53 -0000
Received: from smtprelay0069.hostedemail.com (HELO smtprelay.hostedemail.com) (216.40.44.69) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 26 Oct 2016 05:14:49 -0700
Received: from filter.hostedemail.com (clb03-v110.bra.tucows.net [216.40.38.60]) by smtprelay04.hostedemail.com (Postfix) with ESMTP id 92BD235222C for <bug-class-dbi [...] rt.cpan.org>; Wed, 26 Oct 2016 12:14:43 +0000 (UTC)
Received: from [192.168.0.4] (18.126.112.87.dyn.plus.net [87.112.126.18]) (Authenticated sender: andyc [...] andycragg.com) by omf07.hostedemail.com (Postfix) with ESMTPA for <bug-Class-DBI [...] rt.cpan.org>; Wed, 26 Oct 2016 12:14:42 +0000 (UTC)
Delivered-To: cpan-bug+class-dbi [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #118491] AutoReply: Ubuntu 16.04, MySQL 5.7, "Can't get last insert id" error on inserting row.
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.3.0
Return-Path: <chintzbaby [...] chintzbaby.com>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+class-dbi [...] hipster.bestpractical.com
X-RT-Mail-Extension: class-dbi
Date: Wed, 26 Oct 2016 13:14:33 +0100
X-Spam-Level:
X-Filterd-Recvd-Size: 14090
X-Session-Marker: 616E64796340616E647963726167672E636F6D
To: bug-Class-DBI [...] rt.cpan.org
X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,chintzbaby [...] chintzbaby.com,:,RULES_HIT:1:2:41:69:72:152:355:379:599:800:854:960:962:966:967:973:983:988:989:1189:1208:1212:1221:1260:1261:1313:1314:1345:1359:1381:1431:1436:1437:1516:1517:1518:1575:1588:1589:1592:1594:1605:1617:1685:1730:1776:1792:1801:2068:2069:2196:2198:2199:2200:2525:2553:2566:2682:2685:2859:2902:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3653:3834:3865:3866:3867:3868:3870:3871:3872:3873:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4050:4184:4250:4321:4362:4385:4560:4605:5007:6119:6248:6657:6678:7464:7522:7652:7875:7903:7904:7974:8784:8957:9025:9040:9121:9177:9390:9391:10004:10848:11026:11232:11233:11657:11658:11783:11889:11914:12043:12295:12296:12438:12555:12660:12663:12683:12698:12737:12740:12986:13019:13139:13149:13160:13161:13180:13229:13230:13255:14659:21060:21063:21080:21222:21324:21325:21433:21451:30054:30070:30080:30090:30091,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,D
From: ChintzBaby <chintzbaby [...] chintzbaby.com>
RT-Message-ID: <rt-4.0.18-18816-1477484099-1914.118491-0-0 [...] rt.cpan.org>
Content-Length: 0
content-type: text/plain; charset="utf-8"; format="flowed"
Content-Transfer-Encoding: 7bit
X-RT-Original-Encoding: utf-8
Content-Length: 5296
Download (untitled) / with headers
text/plain 5.1k
Hi, On further inspection, I found this fixed it on my system /usr/local/share/perl/5.22.1/Class/DBI.pm : Line 609 ish : sub _auto_increment_value { my $self = shift; * my $sth = shift;**# Added for MySQL 5.7* my $dbh = $self->db_Main; ... my $id = $dbh->last_insert_id(undef, undef, $self->table, undef) # std || $dbh->{mysql_insertid} # mysql || eval { $dbh->func('last_insert_rowid') } * || $sth->{'mysql_insertid'} # Added for MySQL 5.7* or $self->_croak("Can't get last insert id"); return $id; } sub _insert_row { my $self = shift; my $data = shift; eval { my @columns = keys %$data; my $sth = $self->sql_MakeNewObj( join(', ', @columns), join(', ', map $self->_column_placeholder($_), @columns), ); $self->_bind_param($sth, \@columns); $sth->execute(values %$data); my @primary_columns = $self->primary_columns; * $data->{ $primary_columns[0] } = $self->_auto_increment_value ($sth) # Added $sth for _auto_increment_value* if @primary_columns == 1 && !defined $data->{ $primary_columns[0] }; Anyone have any further thoughts? Andy On 24/10/16 17:51, Bugs in Class-DBI via RT wrote: Show quoted text
> Greetings, > > This message has been automatically generated in response to the > creation of a trouble ticket regarding: > "Ubuntu 16.04, MySQL 5.7, "Can't get last insert id" error on inserting row.", > a summary of which appears below. > > There is no need to reply to this message right now. Your ticket has been > assigned an ID of [rt.cpan.org #118491]. Your ticket is accessible > on the web at: > > https://rt.cpan.org/Ticket/Display.html?id=118491 > > Please include the string: > > [rt.cpan.org #118491] > > in the subject line of all future correspondence about this issue. To do so, > you may reply to this message. > > Thank you, > bug-Class-DBI@rt.cpan.org > > ------------------------------------------------------------------------- > Hi, > > * Class-DBI-v3.0.17 > * Perl : v5.22.1 > * Ubuntu 16.04 : Linux 4.4.0-45-lowlatency #66-Ubuntu SMP PREEMPT Wed > Oct 19 14:57:51 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux > * MySQL : Ver 14.14 Distrib 5.7.15, for Linux (x86_64) > * DBD-mysql-4.038 > * libmysqlclient.so.20.3.2 > > > I've upgraded Ubuntu from 15.10 (MySQL5.6) and now have MySQL 5.7, and I > get "Can't get last insert id" when inserting a row into a table, where > in 5.6/15.10 it worked fine. > > The row does get inserted into the table ok, but the inserted row_id is > not returned by MySQL : > > Line 609 in /usr/local/share/perl/5.22.1/Class/DBI.pm : > sub _auto_increment_value { > ... > my $id = $dbh->last_insert_id(undef, undef, $self->table, undef) > # std > || $dbh->{mysql_insertid} # mysql > || eval { $dbh->func('last_insert_rowid') } > *or $self->_croak("Can't get last insert id");* > > Called from my CGI program : > use DBI; > use MyApp; > use MyApp::PictureTag; > ... > MyApp::PictureTag->insert ( > { > Picture_id => $PicId, > Tag_id => $TagId, > } > ); > > PictureTag has a primary auto-increment key. > > DBI Trace : > > -> ping for DBD::mysql::db > (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30)~0x55b68bc45e68) > thr#55b68a5a8220 > T <- ping= ( 1 ) [1 items] at /usr/local/share/perl/5.22.1/Ima/DBI.pm > line 326 via at /usr/local/share/perl/5.22.1/Class/DBI.pm line 600
> >> last_insert_id DISPATCH
> (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30) rc1/3 @5 g2 ima2801 > pid#13281) at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 628 > -> last_insert_id for DBD::mysql::db > (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30)~0x55b68bc45e68 undef > undef 'PictureTag' undef) thr#55b68a5a8220 > T <- last_insert_id= ( '0' ) [1 items] at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 628
> >> FETCH DISPATCH
> (DBIx::ContextualFetch::db=HASH(0x55b68bc45e68) rc2/23 @2 g2 ima404 > pid#13281) at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 628 > -> FETCH for DBD::mysql::db > (DBIx::ContextualFetch::db=HASH(0x55b68bc45e68)~INNER 'mysql_insertid') > thr#55b68a5a8220 > T <- FETCH= ( '0' ) [1 items] at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 628
> >> func DISPATCH
> (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30) rc1/3 @2 g2 ima6 > pid#13281) at /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 via at > /usr/local/share/perl/5.22.1/Class/DBI.pm line 609 > -> last_insert_rowid for DBD::mysql::db > (DBIx::ContextualFetch::db=HASH(0x55b68bc45d30)~0x55b68bc45e68) > thr#55b68a5a8220 > > I've seen some reference to this here : > https://rt.cpan.org/Public/Bug/Display.html?id=108000 and in the change > notes for 4.035_01, but I do not know how to solve this issue (apart > from going back to MySQL 5.6). > > I've scrubbed Google and I can't find anyone else who has had this issue! > > Thanks much for any help. > Andy > > >
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: 8bit
X-RT-Original-Encoding: utf-8
Content-Length: 7077
X-MS-Exchange-Crosstenant-Fromentityheader: Hosted
Spamdiagnosticmetadata: NSPM
MIME-Version: 1.0
Spamdiagnosticoutput: 1:99
X-Spam-Flag: NO
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Content-Type: multipart/alternative; boundary="_000_BLUPR03MB1363410343AAE808BDED1DA5B1B10BLUPR03MB1363namp_"
X-Spam-Score: -4.2
X-Exchange-Antispam-Report-Test: UriScan:;
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id DFB6724026B for <cpan-bug+class-dbi [...] hipster.bestpractical.com>; Thu, 17 Nov 2016 12:23:16 -0500 (EST)
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 1OzROrfNyPHp for <cpan-bug+class-dbi [...] hipster.bestpractical.com>; Thu, 17 Nov 2016 12:23:15 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 9F38324002C for <bug-class-dbi [...] rt.cpan.org>; Thu, 17 Nov 2016 12:23:15 -0500 (EST)
Received: (qmail 19412 invoked by alias); 17 Nov 2016 17:23:15 -0000
Received: from smtp-277a-c.mmm.com (HELO smtp-277A-C.mmm.com) (136.229.8.25) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Thu, 17 Nov 2016 09:23:08 -0800
Received: from mailgate03.mmm.com (unknown [136.229.2.140]) by Websense Email with ESMTPS id 00D78F78DD080 for <bug-class-dbi [...] rt.cpan.org>; Thu, 17 Nov 2016 17:23:00 +0000 (GMT)
Received: from mail-dm3nam03lp0017.outbound.protection.outlook.com (HELO NAM03-DM3-obe.outbound.protection.outlook.com) ([207.46.163.17]) by mailgate03c.mmm.com with ESMTP/TLS/AES256-SHA; 17 Nov 2016 11:23:03 -0600
Received: from BLUPR03MB1363.namprd03.prod.outlook.com (10.163.80.29) by BLUPR03MB1364.namprd03.prod.outlook.com (10.163.80.30) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.734.8; Thu, 17 Nov 2016 17:23:02 +0000
Received: from BLUPR03MB1363.namprd03.prod.outlook.com ([10.163.80.29]) by BLUPR03MB1363.namprd03.prod.outlook.com ([10.163.80.29]) with mapi id 15.01.0734.007; Thu, 17 Nov 2016 17:23:02 +0000
Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=rschulz [...] mmm.com;
Delivered-To: cpan-bug+class-dbi [...] hipster.bestpractical.com
Subject: [rt.cpan.org #118491]
X-Spam-Check-BY: la.mx.develooper.com
Thread-Index: AQHSQPaNOsMg4V0HiE63SfcyfONUMg==
Date: Thu, 17 Nov 2016 17:23:02 +0000
X-Originatororg: mmm.com
X-Spam-Level:
X-MS-Office365-Filtering-Correlation-ID: e82c30ba-763a-44b1-f8fa-08d40f0e6285
X-MS-Exchange-Crosstenant-ID: facac3c4-e2a5-4257-af76-205c8a821ddb
To: "bug-class-dbi [...] rt.cpan.org" <bug-class-dbi [...] rt.cpan.org>
X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:BLUPR03MB1364;
X-Exchange-Antispam-Report-Cfa-Test: BCL:0;PCL:0;RULEID:(6040281)(6060326)(6045074)(601004)(2401047)(5005006)(8121501046)(10201501046)(3002001)(6061324)(6046074)(6041223);SRVR:BLUPR03MB1364;BCL:0;PCL:0;RULEID:;SRVR:BLUPR03MB1364;
X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(6009001)(7916002)(66654002)(54164003)(189002)(199003)(107886002)(54356999)(99286002)(2906002)(81166006)(77096005)(9686002)(76576001)(3846002)(2900100001)(2501003)(50986999)(8936002)(105586002)(106356001)(68736007)(106116001)(102836003)(6116002)(3660700001)(3280700002)(2351001)(189998001)(81156014)(33656002)(19627405001)(101416001)(7846002)(66066001)(92566002)(7736002)(450100001)(74316002)(8676002)(97736004)(86362001)(122556002)(6506003)(5660300001)(7696004)(6916009)(6606003)(110136003)(87936001);DIR:OUT;SFP:1101;SCL:1;SRVR:BLUPR03MB1364;H:BLUPR03MB1363.namprd03.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en;
X-Spam-Status: No, score=-4.2 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-0.001] autolearn=ham
X-Microsoft-Exchange-Diagnostics: 1;BLUPR03MB1364;7:i03YHABSeYacTRfwzLMhFD1Tv3X8ge4FCh+LvYsIB6m9lfXda2JpkY/LfDpMcE+TQ2YBrIi505tfiN3TjxJIjMRn/dhUwXyeW3meqBPNw0ri3267McUuUTpg4LfSeKqN4NZdMUFBY78o74wN/SQMV9Ic6vkV8TozYCLd8MeyHQd/jFK0WF67dyzUX0YjS0cF1XHvzh1MMOYXebnd+BLr0YTrU1nJiMWqbmG2ybsdtvwGL5w+SJJubATbkifNv4Mhlpl/NYjx1yNlxT4xiqeGLJxWYk5STZBZPlpzZHMv9WZv54ekWoXvBfUcqkBmEeC9OKwoQBd8jw6W4NjD0aZWxwxvI4eVIXr5pWlM0xvUHow=
Received-SPF: None (protection.outlook.com: mmm.com does not designate permitted sender hosts)
X-RT-Interface: API
Content-Language: en-US
Message-ID: <BLUPR03MB1363410343AAE808BDED1DA5B1B10 [...] BLUPR03MB1363.namprd03.prod.outlook.com>
X-Microsoft-Antispam-PRVS: <BLUPR03MB1364D6F5488F5AB0B1B154AEB1B10 [...] BLUPR03MB1364.namprd03.prod.outlook.com>
X-MS-Tnef-Correlator:
X-Extloop1: 1
Return-Path: <rschulz [...] mmm.com>
X-RT-Mail-Extension: class-dbi
X-Original-To: cpan-bug+class-dbi [...] hipster.bestpractical.com
X-MS-Exchange-Crosstenant-Originalarrivaltime: 17 Nov 2016 17:23:02.1076 (UTC)
X-Forefront-PRVS: 01294F875B
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #118491]
X-Originating-Ip: [132.245.4.133]
Accept-Language: en-US
From: Robert Schulz <rschulz [...] mmm.com>
X-MS-Exchange-Transport-Crosstenantheadersstamped: BLUPR03MB1364
RT-Message-ID: <rt-4.0.18-30279-1479403397-629.118491-0-0 [...] rt.cpan.org>
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 324
Download (untitled) / with headers
text/plain 324b
Please consider this a pile-on vote for fixing this bug. From what I can see, DBI recommends $sth->{mysql_insertid} over the $dbh method anyway. Ive confirmed Andy's solution. The only other bit I did not see in his notes: - $self->_auto_increment_value + $self->_auto_increment_value($sth) Many Thanks to All
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: utf-8
Content-Length: 1009
Download (untitled) / with headers
text/html 1009b
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-30279-1479403397-629.118491-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <BLUPR03MB1363410343AAE808BDED1DA5B1B10 [...] BLUPR03MB1363.namprd03.prod.outlook.com> <rt-4.0.18-30279-1479403397-629.118491-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-22422-1493302679-1836.118491-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 52
Another vote to please include this fix. Thank you.


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.