Skip Menu |

This queue is for tickets about the CPAN-Dependency CPAN distribution.

Report information
The Basics
Id: 47409
Status: resolved
Priority: 0/
Queue: CPAN-Dependency

People
Owner: Nobody in particular
Requestors: doom [...] kzsu.stanford.edu
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.15
Fixed in: 0.16



Subject: DBD::SQLite::db prepare failed: no such column: dist.dist_without_version(1)
Using a recent sqlite db file from cpants, I get this error: DBD::SQLite::db prepare failed: no such column: dist.dist_without_version(1) at dbdimp.c line 271 at /usr/local/share/perl/5.10.0/CPAN/Dependency.pm line 598. When trying to run code very similar to the CPAN::Dependency SYNOPSIS. use CPAN::Dependency; my $cpandep = new CPAN::Dependency; $cpandep->load_cpants_db(file => $cpants_db_file); $cpandep->calculate_score; my %score = $cpandep->score_by_dists; my @dists = sort { $score{$b} <=> $score{$a} } keys %score; print "Top 10 modules\n"; for my $dist (@dists[0..9]) { printf "%5d %s\n", $score{$dist}, $dist; } Versions: CPAN-Dependency-0.15 This is perl, v5.10.0 built for x86_64-linux-gnu-thread-multi Linux fineline 2.6.24-16-generic #1 SMP Thu Apr 10 12:47:45 UTC 2008 x86_64 GNU/Linux
Subject: Re: [rt.cpan.org #47409] DBD::SQLite::db prepare failed: no such column: dist.dist_without_version(1)
Date: Tue, 30 Jun 2009 01:28:10 +0200
To: bug-CPAN-Dependency [...] rt.cpan.org
From: Sébastien Aperghis-Tramoni <saper [...] cpan.org>
Hello, Joseph Brenner wrote via RT: Show quoted text
> Using a recent sqlite db file from cpants, I get this error: > > DBD::SQLite::db prepare failed: no such column: > dist.dist_without_version(1) at dbdimp.c line 271 at > /usr/local/share/perl/5.10.0/CPAN/Dependency.pm line 598.
Unsurprising as CPANTS has evolved quite a quite while I wasn't looking. As stated in the documentation, CPAN::Dependency is no longer really maintained as there are other modules existing on the CPAN. I nevertheless took a look at this, and I think the following patch should fix the problem: --- lib/CPAN/Dependency.pm 2008-03-05 09:03:52.000000000 +0100 +++ lib/CPAN/Dependency.pm 2009-06-30 01:20:30.000000000 +0200 @@ -596,7 +596,7 @@ or croak "fatal: Can't read SQLite database: $DBI::errstr"; my $dists_sth = $dbh->prepare(q{ - SELECT dist.dist, dist.dist_without_version, author.pauseid, author.name + SELECT dist.id, dist.dist, author.pauseid, author.name FROM dist, author WHERE author.id=dist.author }); Regards -- Sébastien Aperghis-Tramoni Close the world, txEn eht nepO.