Skip Menu |

This queue is for tickets about the CPANPLUS CPAN distribution.

Report information
The Basics
Id: 54223
Status: open
Priority: 0/
Queue: CPANPLUS
People
Owner: Nobody in particular
Requestors: avar [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Critical
Broken in: 0.9001
Fixed in: (no value)

History Show all quoted text
  Tue Feb 02 11:01:20 2010 avar [...] cpan.org - Ticket created
Subject: CPANPLUS::Internals::Source::SQLite fails with "DBI error: no such table: module"
I did as the cpanplus::shell tip suggested and switched to sqlite with: s conf source_engine CPANPLUS::Internals::Source::SQLite; s save s selfupdate enabled_features After restarting CPANPLUS I get: CPAN Terminal> a AVAR CPAN Terminal> m Tie CPAN Terminal> o [MSG] No '/home/avar/.cpanplus/custom-sources' dir, skipping custom sources [MSG] No '/home/avar/.cpanplus/custom-sources' dir, skipping custom sources [ERROR] DBI error: no such table: module [ERROR] DBI error: no such table: module [ERROR] DBI error: no such table: module [ ... output just goes on ...] ^CCaught SIGINT [ERROR] DBI error: no such table: module [ERROR] DBI error: no such table: module [... a few hundred lines ...] [ERROR] DBI error: no such table: module ^CGot another SIGINT [ERROR] DBI error: no such table: module [...] [ERROR] DBI error: no such table: module ^CGot another SIGINT [ERROR] Error finding installed files in '/usr/share/perl5': Died at /usr/share/perl/5.10/CPANPLUS/Shell.pm line 158. [ERROR] DBI error: no such table: module [ERROR] DBI error: no such table: module When switching away from sqlite I get: CPAN Terminal> s conf source_engine CPANPLUS::Internals::Source::Memory Key 'source_engine' was set to 'CPANPLUS::Internals::Source::Memory' CPAN Terminal> s save Configuration successfully saved to CPANPLUS::Config::User (/home/avar/.cpanplus/lib/CPANPLUS/Config/User.pm) CPAN Terminal> s selfupdate enabled_features [MSG] No '/home/avar/.cpanplus/custom-sources' dir, skipping custom sources [MSG] No '/home/avar/.cpanplus/custom-sources' dir, skipping custom sources [ERROR] DBI error: no such table: module [ERROR] DBI error: no such table: module The following updates will take place: Modules for 'md5' support: No upgrades required Modules for 'prefer_makefile' support: No upgrades required Modules for 'shell' support: No upgrades required Modules for 'storable' support: No upgrades required Updating your CPANPLUS installation [ERROR] DBI error: no such table: module [ERROR] DBI error: no such table: module
  Tue Feb 02 11:36:08 2010 avar [...] cpan.org - Correspondence added

Message body is not shown because it is too large.

  Tue Feb 02 11:36:15 2010 avar [...] cpan.org - Status changed from 'new' to 'open'
  Tue Feb 02 11:37:21 2010 avar [...] cpan.org - Correspondence added
Apply this patch to the SQLite backend whatever you do, it will report errors to the user instead of just looping like above.
Subject: cpanplus-sqlite-raiseerror.patch
Index: CPANPLUS/Internals/Source/SQLite.pm =================================================================== --- CPANPLUS/Internals/Source/SQLite.pm (revision 2757) +++ CPANPLUS/Internals/Source/SQLite.pm (working copy) @@ -48,7 +48,7 @@ $Dbh = DBIx::Simple->connect( "dbi:SQLite:dbname=" . $self->__sqlite_file, '', '', - { AutoCommit => 1 } + { RaiseError => 1, AutoCommit => 1 } ); #$Dbh->dbh->trace(1);