ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases

[robin at miriup.de]

The following reply was made to PR ports/94668; it has been noted by GNATS.

From: robin at miriup.de
To: "Edwin Groothuis" <edwin at mavetju.org>
Cc:  
Subject: Re: ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases
Date: Tue, 10 Apr 2007 07:12:38 -0700

 On 19 Mrz. 2006, 02:44, Edwin Groothuis <e... at mavetju.org> wrote:
 > >Number:         94668
 > >Category:       ports
 > >Synopsis:       databases/p5-DBD-SQLite doesn't like new SQLite databases
 > >Confidential:   no
 > >Severity:       serious
 > >Priority:       medium
 > >Responsible:    freebsd-ports-bugs
 > >State:          open
 > >Quarter:
 > >Keywords:
 > >Date-Required:
 > >Class:          sw-bug
 > >Submitter-Id:   current-users
 > >Arrival-Date:   Sun Mar 19 01:50:12 GMT 2006
 > >Closed-Date:
 > >Last-Modified:
 > >Originator:     Edwin Groothuis
 > >Release:        FreeBSD 6.0-RELEASE i386
 > >Organization:
 > -
 > >Environment:
 >
 > System: FreeBSD k7.mavetju 6.0-RELEASE FreeBSD 6.0-RELEASE #0: Thu Nov 3 09:36:13 UTC 2005 r... at x64.samsco.home:/usr/obj/usr/src/sys/GENERIC i386
 >
 > >Description:
 >
 > Databases created with sqlite3 can't be read with p5-DBD-SQLite anymore.
 >
 > >How-To-Repeat:
 >
 > [~/s] edwin at k7>sqlite3 foo.db
 > SQLite version 3.3.4
 > Enter ".help" for instructions
 > sqlite> create table foo ( bar int);
 > sqlite> .schema
 > CREATE TABLE foo ( bar int);
 > sqlite> [~/s] edwin at k7>ls -al
 > total 10
 > drwxr-xr-x   2 edwin  edwin   512 Mar 19 12:36 .
 > drwxr-xr-x  81 edwin  edwin  5632 Mar 19 12:36 ..
 > -rw-r--r--   1 edwin  edwin  2048 Mar 19 12:36 foo.db
 >
 > [~/s] edwin at k7>perl -we 'use DBI;use strict; my $dbh=DBI-name=foo.db","","");my $sth=$dbh->prepare("SELECT * FROM foo");'
 > DBD::SQLite::dbpreparefailed:unsupportedfileformat(1) atdbdimp.cline 269 at -e line 1.
 >
 > >Fix:
 >
 > I would normally say "upgrade to the latest version", but there is
 > no never version available from CPAN. Nor in rt.cpan.org. Nor
 > anywhere else.
 >
 >
 >
 >
 >
 > >Release-Note:
 > >Audit-Trail:
 > >Unformatted:
 
 i experienced the same problem and i found a solution that worked for
 me:
 
 download the newest version of SQLite (3.3.14)
 
 use the command "sqlite3 [filename of db] .dump | sqlite3 [filename of
 new db]
 
 this new db file should work.
 
 
 wish you all the best,
 robin