multiple DBI::Format's in CPAN installing to different locations, and $VERSION bug in DBI-Shell-11.9/lib/DBI/Format/SQLMinus.pm

DBI::Format comes with

    DBI-1.32		in lib/DBI/Format.pm as VERSION 11.4
and
    DBI-Shell-11.9	in lib/DBI/Format.pm as VERSION 11.8

According to the .packlist files DBI installs Format.pm in
	    /usr/local/lib/perl5/site_perl/5.9.0/i686-linux/DBI
but DBI/Shell installs the newer version in
	    /usr/local/lib/perl5/site_perl/5.9.0/DBI/Format.pm

In my @INC,
    /usr/local/lib/perl5/site_perl/5.9.0/i686-linux
(where DBI installs the older Format.pm) comes before
    /usr/local/lib/perl5/site_perl/5.9.0
(where the newer DBI-Shell is installed)

This causes the older DBI::Format to be used, and CPAN.pm
to report that an upgrade is in order

Shouldn't both of these packages (DBI and DBI-Shell) install
DBI::Format in the same location?

Where is the 'correct' location for DBI::Format?

Also, both the CPAN "r" command and the
test code described in perldoc CPAN
    perl -MExtUtils::MakeMaker -le         \
	'print MM->parse_version(shift)' \
		DBI-Shell-11.9/lib/DBI/Format/SQLMinus.pm
report an error in SQLMinus.pm

Could not eval '
            package ExtUtils::MakeMaker::_version;
            no strict;

            local $DBI::Format::SQLMinus::VERSION;
            $DBI::Format::SQLMinus::VERSION=undef; do {
                $DBI::Format::SQLMinus::VERSION =
            }; $DBI::Format::SQLMinus::VERSION
        ' in /usr/local/lib/perl5/site_perl/5.9.0/DBI/Format/SQLMinus.pm: syntax error at (eval 83) line 8, at EOF

Because it can't determine the version number from the lines

$DBI::Format::SQLMinus::VERSION =
        $DBI::Format::SQLMinus::VERSION =
                (qw$Revision: 11.8 $)[1];

in DBI-Shell-11.9/lib/DBI/Format/SQLMinus.pm

Perldoc Extutils::MakeMaker document the format for the $VERSION
in the description of VERSION_FROM as needing to be on one line,
(not the 3 lines in SQLMinus.pm)





0
david
12/9/2002 5:43:41 PM
perl.dbi.users 11073 articles. 1 followers. Follow

3 Replies
704 Views

Similar Articles

[PageSpeed] 14

On Mon, Dec 09, 2002 at 09:43:41AM -0800, David Dyck wrote:
> 
> DBI::Format comes with
> 
>     DBI-1.32		in lib/DBI/Format.pm as VERSION 11.4
> and
>     DBI-Shell-11.9	in lib/DBI/Format.pm as VERSION 11.8
> 
> According to the .packlist files DBI installs Format.pm in
> 	    /usr/local/lib/perl5/site_perl/5.9.0/i686-linux/DBI
> but DBI/Shell installs the newer version in
> 	    /usr/local/lib/perl5/site_perl/5.9.0/DBI/Format.pm
> 
> In my @INC,
>     /usr/local/lib/perl5/site_perl/5.9.0/i686-linux
> (where DBI installs the older Format.pm) comes before
>     /usr/local/lib/perl5/site_perl/5.9.0
> (where the newer DBI-Shell is installed)
> 
> This causes the older DBI::Format to be used, and CPAN.pm
> to report that an upgrade is in order
> 
> Shouldn't both of these packages (DBI and DBI-Shell) install
> DBI::Format in the same location?

It's a side effect of the fact that the DBI-Shell-11.9 distribution
is pure-perl.

> Where is the 'correct' location for DBI::Format?
> 
> Also, both the CPAN "r" command and the
> test code described in perldoc CPAN
>     perl -MExtUtils::MakeMaker -le         \
> 	'print MM->parse_version(shift)' \
> 		DBI-Shell-11.9/lib/DBI/Format/SQLMinus.pm
> report an error in SQLMinus.pm
> 
> Could not eval '
>             package ExtUtils::MakeMaker::_version;
>             no strict;
> 
>             local $DBI::Format::SQLMinus::VERSION;
>             $DBI::Format::SQLMinus::VERSION=undef; do {
>                 $DBI::Format::SQLMinus::VERSION =
>             }; $DBI::Format::SQLMinus::VERSION
>         ' in /usr/local/lib/perl5/site_perl/5.9.0/DBI/Format/SQLMinus.pm: syntax error at (eval 83) line 8, at EOF
> 
> Because it can't determine the version number from the lines
> 
> $DBI::Format::SQLMinus::VERSION =
>         $DBI::Format::SQLMinus::VERSION =
>                 (qw$Revision: 11.8 $)[1];
> 
> in DBI-Shell-11.9/lib/DBI/Format/SQLMinus.pm
> 
> Perldoc Extutils::MakeMaker document the format for the $VERSION
> in the description of VERSION_FROM as needing to be on one line,
> (not the 3 lines in SQLMinus.pm)

The DBI-Shell distribution needs fixing and a new release made.
Hopefully Tom will do that ASAP.


The underlying issue is more tricky. I want to let Tom and others
develop the DBI::Shell and related components faster than I was
making DBI releases. I had planned for Tom's DBI::Shell to also be
released as part of the DBI so people just installing the DBI would
get the benefits of Tom's work.

It turned out that Tom had used a bunch of recent perl features that
would have meant the DBI would no longer pass tests on many systems
(although some would be okay after installing some more modules).
So at the last minute I opted not to include the newer DBI::Shell.

I think Tom is thinking about moving some of the new functionality
into runtime 'plug-in' modules. If the base system can work with
perl 5.005_03 then I'll happily include it in a future DBI release.

The ball is currently in Tom's court.

Tim.
0
Tim
12/10/2002 10:08:39 AM
On Tue, Dec 10, 2002 at 10:08:39AM +0000, Tim Bunce wrote:
> On Mon, Dec 09, 2002 at 09:43:41AM -0800, David Dyck wrote:
> > 
> > DBI::Format comes with
> > This causes the older DBI::Format to be used, and CPAN.pm
> > to report that an upgrade is in order
> > 
> > Shouldn't both of these packages (DBI and DBI-Shell) install
> > DBI::Format in the same location?
> 
> It's a side effect of the fact that the DBI-Shell-11.9 distribution
> is pure-perl.

When you install the newer version use make install UNINST=1
It will take care of the problem.

> > Could not eval '
> >             package ExtUtils::MakeMaker::_version;
> >             no strict;
> > 
> >             local $DBI::Format::SQLMinus::VERSION;
> >             $DBI::Format::SQLMinus::VERSION=undef; do {
> >                 $DBI::Format::SQLMinus::VERSION =
> >             }; $DBI::Format::SQLMinus::VERSION
> >         ' in /usr/local/lib/perl5/site_perl/5.9.0/DBI/Format/SQLMinus.pm: syntax error at (eval 83) line 8, at EOF

I've the version numbers fixed, for the modules.  I'm going to bump the
version up so cpan isn't confused.

> It turned out that Tom had used a bunch of recent perl features that
> would have meant the DBI would no longer pass tests on many systems
> (although some would be okay after installing some more modules).
> So at the last minute I opted not to include the newer DBI::Shell.

I've pulled the IO::Tee stuff out of Shell.pm and made it a plug-in.  This
should allow it to work as the standard DBI distro ...

Upload the new version tonight.

Tom

-- 
Thomas A. Lowery
See DBI/FAQ http://www.xmlproj.com/cgi/fom.cgi
0
tl
12/13/2002 11:43:47 PM
On Fri, Dec 13, 2002 at 06:43:47PM -0500, Thomas A. Lowery wrote:
> > It turned out that Tom had used a bunch of recent perl features that
> > would have meant the DBI would no longer pass tests on many systems
> > (although some would be okay after installing some more modules).
> > So at the last minute I opted not to include the newer DBI::Shell.
> 
> I've pulled the IO::Tee stuff out of Shell.pm and made it a plug-in.  This
> should allow it to work as the standard DBI distro ...

I think you'll also need to ship Test::More (under the ./t/ directory)
and tweak @INC in the tests to use it.

Tim.
0
Tim
12/15/2002 9:54:28 PM
Reply:

Similar Artilces:

DBI::Format in DBI-1.34 vs. DBI-Shell-11.91
There seem to be conflicting versions of DBI::Format in DBI-1.34 and DBI-Shell-11.91. After upgrading to the recent DBI-1.34 I again get a warning from the CPAN "r" command which reports that there is a more recent version of DBI::Format to be found in DBI-Shell-11.91.tar. When I read that the new DBI-1.34 removed the old DBI::Shell from distribution, I was surporised that it kept DBI::Format. I couldn't find any perl references in DBI-1.34 that refered to DBI::Format, so perhaps if the official DBI::Format is being kept up to date in DBI-Shell-11.91, you could ...

POSSIBLE BUG IN Win32 DBI INSTALL MODULE: DBI "prepare" no work FW: List 'dbi-users' closed to public posts
I have ActiveState Win32perl running. I installed fresh DBI, DBD, etc. from perl ppm.pl> prompt. But prepare( ) doesn't work (see below). perldoc DBI/DBD/DBI-FAQ are not useful since they assume it works. Any hints? Art www.mp3.com/ArthurSulit Classical Artist recently charted above Madonna -----Original Message----- From: Art Sulit [mailto:art@prs.net] Sent: Saturday, January 20, 2001 1:51 PM To: Webmaster@ActiveState.com Subject: POSSIBLE BUG IN YOUR DBI INSTALL MODULE: DBI "prepare" no work Hello, THERE IS A POSSIBLE BUG IN YOUR DBI INSTALL M...

[perl5-dbi/DBI-Test] 259b89: perltidy lib/DBI/Mock.pm
----==_mimepart_51de492438906_56b10afdd8124440 Date: Wed, 10 Jul 2013 22:56:52 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <51de492439365_56b10afdd81245a8@hookshot-fe2-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/DBI-Test Commit: 259b8946d0112c630dfc1d1807824fd6305ca46c https://github.com/perl5-dbi/DBI-Test/commit/259b8946d0112c630dfc1d1807824fd6305ca46c Author: Jens Rehsack <sno@netbsd.org> Date: 2013-07-10 (Wed, 10 Jul 2013) Changed ...

DBI: Can't locate DBI.pm
What's this error? The DBI package is not installed? "Software error: [Thu Mar 6 15:01:54 2003] DBI.pm: Can't locate DBI.pm in @INC (@INC contains: /usr/local/lib/perl5/5.00503/i386-freebsd /usr/local/lib/perl5/5.00503 /usr/local/lib/site_perl /usr/local/lib/site_perl .) at /usr/local/etc/httpd/vhosts/vencendo/criabasededados.pl line 6. BEGIN failed--compilation aborted at /usr/local/etc/httpd/vhosts/vencendo/criabasededados.pl line 6." Paulo _________________________________________________________________ MSN Hotmail, o maior webmail do Brasil. ...

[perl5-dbi/dbi] 94bae3: Change DBI's docs from svn to git
----==_mimepart_51972cfd79b68_36ad7a7de415599e Date: Sat, 18 May 2013 00:25:49 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <51972cfd7a5db_36ad7a7de41560da@hookshot-fe2-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/dbi Commit: 94bae38fb14777ad587d8cd343cf39f3990d6cfc https://github.com/perl5-dbi/dbi/commit/94bae38fb14777ad587d8cd343cf39f3990d6cfc Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl> Date: 2013-05-18 (Sat, 18 May 2013) Chang...

[perl5-dbi/DBI-Test] 5cf68f: add lib/DBI/Test/DSN/Provider/Base.pm
----==_mimepart_5200b27ad097b_429583bd501034ce Date: Tue, 06 Aug 2013 01:23:22 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <5200b27ad1491_429583bd5010352a@hookshot-fe2-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/DBI-Test Commit: 5cf68fcc017e162265b676bf7343878aa2832462 https://github.com/perl5-dbi/DBI-Test/commit/5cf68fcc017e162265b676bf7343878aa2832462 Author: Jens Rehsack <sno@netbsd.org> Date: 2013-08-06 (Tue, 06 Aug 2013) Changed ...

CPAN.pm installs DBI-1.35 instead of DBI-1.36?
-ponder- $ perl -MCPAN -e 'shell' > install DBI Installs DBI-1.35 instead of the brand spanking new DBI-1.36? Or is it = just me? Or am I an idiot? $ perl -MCPAN -e 'print $CPAN::VERSION' 1.70 (Default CPAN install.) Thanks, j -------- Maybe this would be a good thing to list in this report too? $ cat /usr/lib/perl5/5.6.0/CPAN/Config.pm # This is CPAN.pm's systemwide configuration file. This file provides # defaults for users, and the values can be changed in a per-user # configuration file. The user-config file is being looked for as...

[perl5-dbi/dbi] #9
----==_mimepart_52cd1a0b476b4_27ff1395d546985e Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Branch: refs/heads/topic/concurrency_testfixes Home: https://github.com/perl5-dbi/dbi ----==_mimepart_52cd1a0b476b4_27ff1395d546985e-- ...

[perl5-dbi/DBI-Test] a2d1b2: create separate tests for DBI and DBI::Mock ...
----==_mimepart_51f946a54bb1b_2af891bd4c100430 Date: Wed, 31 Jul 2013 10:17:25 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <51f946a54c721_2af891bd4c100582@hookshot-fe3-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/DBI-Test Commit: a2d1b22d134be0ca353e0f0b312fb14da24c798e https://github.com/perl5-dbi/DBI-Test/commit/a2d1b22d134be0ca353e0f0b312fb14da24c798e Author: Jens Rehsack <sno@netbsd.org> Date: 2013-07-31 (Wed, 31 Jul 2013) Changed ...

[perl5-dbi/dbi] 0b3fe3: Fixed VERSION regression in DBI::SQL::Nano
----==_mimepart_519541eb800_3b43d7fdd4200cf Date: Thu, 16 May 2013 13:30:35 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <519541eb3946_3b43d7fdd42019d@hookshot-fe6-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/dbi Commit: 0b3fe3d8b14c2280e27032c8ea52d1a3c4c133c1 https://github.com/perl5-dbi/dbi/commit/0b3fe3d8b14c2280e27032c8ea52d1a3c4c133c1 Author: Tim Bunce <Tim.Bunce@pobox.com> Date: 2013-05-16 (Thu, 16 May 2013) Changed paths: M...

[perl5-dbi/dbi] 0c17b7: Include Jens' work for DBI-Test
----==_mimepart_521d9d9e8d573_74699e7d4814086d Date: Tue, 27 Aug 2013 23:50:06 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <521d9d9e8e411_74699e7d48140935@hookshot-fe4-pe1-prd.aws.github.net.mail> Branch: refs/heads/dir_search_hashes Home: https://github.com/perl5-dbi/dbi Commit: 0c17b78ff80873945276cd8ffc08876be8ebfd8d https://github.com/perl5-dbi/dbi/commit/0c17b78ff80873945276cd8ffc08876be8ebfd8d Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl> Date: 2013-08-12 (Mon, 12 Aug 2013)...

[perl5-dbi/dbi] 6a5ada: Support multiple folders in DBD::File's f_dir attr...
----==_mimepart_51b7055911335_4276b5bddc1132ba Date: Tue, 11 Jun 2013 04:09:13 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <51b7055912155_4276b5bddc1133b1@hookshot-fe6-pe1-prd.aws.github.net.mail> Branch: refs/heads/f_dir-ref Home: https://github.com/perl5-dbi/dbi Commit: 6a5ada7b9e36edc32be5d34a39854660a4bf70b7 https://github.com/perl5-dbi/dbi/commit/6a5ada7b9e36edc32be5d34a39854660a4bf70b7 Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl> Date: 2013-06-11 (Tue, 11 Jun 2013) Ch...

[perl5-dbi/dbi] 6a5ada: Support multiple folders in DBD::File's f_dir attr... #2
----==_mimepart_51c8b834b8313_3a82a5dde0935bd Date: Mon, 24 Jun 2013 14:20:52 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-ID: <51c8b834b9aab_3a82a5dde0936c3@hookshot-fe2-pe1-prd.aws.github.net.mail> Branch: refs/heads/master Home: https://github.com/perl5-dbi/dbi Commit: 6a5ada7b9e36edc32be5d34a39854660a4bf70b7 https://github.com/perl5-dbi/dbi/commit/6a5ada7b9e36edc32be5d34a398= 54660a4bf70b7 Author: H.Merijn Brand - Tux <h.m.brand@xs4all.nl> Date: 2013-06-11 (Tue, 11 Jun 201...

[perl5-dbi/dbi]
----==_mimepart_515e8f3785207_523740c1306299e Date: Fri, 05 Apr 2013 01:45:43 -0700 Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-ID: <515e8f3787c27_523740c13063084@hookshot-fe5-pe1-prd.aws.github.net.mail> Branch: refs/heads/trunk Home: https://github.com/perl5-dbi/dbi ----==_mimepart_515e8f3785207_523740c1306299e-- ...

Web resources about - multiple DBI::Format's in CPAN installing to different locations, and $VERSION bug in DBI-Shell-11.9/lib/DBI/Format/SQLMinus.pm - perl.dbi.users

Resources last updated: 1/19/2016 2:07:57 AM