Date: Wed, 11 Apr 2007 09:10:06 GMT From: robin@miriup.de To: perl@FreeBSD.org Subject: Re: ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases Message-ID: <200704110910.l3B9A6EA044361@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
The following reply was made to PR ports/94668; it has been noted by GNATS.
From: robin@miriup.de
To: "Edwin Groothuis" <edwin@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...@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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200704110910.l3B9A6EA044361>