Databases created with sqlite3 can't be read with p5-DBD-SQLite anymore. 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. How-To-Repeat: [~/s] edwin@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@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@k7>perl -we 'use DBI;use strict; my $dbh=DBI-name=foo.db","","");my $sth=$dbh->prepare("SELECT * FROM foo");' DBD::SQLite::db prepare failed: unsupported file format(1) at dbdimp.c line 269 at -e line 1.
Responsible Changed From-To: freebsd-ports-bugs->perl Over to maintainer
State Changed From-To: open->closed Fixed in p5-DBD-SQLite 1.11_2.
On 19 Mrz. 2006, 02:44, Edwin Groothuis <e...@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...@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@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@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@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