From owner-freebsd-perl@FreeBSD.ORG Wed Apr 11 09:10:06 2007 Return-Path: X-Original-To: perl@hub.freebsd.org Delivered-To: freebsd-perl@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id D850C16A403 for ; Wed, 11 Apr 2007 09:10:06 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [69.147.83.40]) by mx1.freebsd.org (Postfix) with ESMTP id 7437813C4C2 for ; Wed, 11 Apr 2007 09:10:06 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.4/8.13.4) with ESMTP id l3B9A6Kw044362 for ; Wed, 11 Apr 2007 09:10:06 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id l3B9A6EA044361; Wed, 11 Apr 2007 09:10:06 GMT (envelope-from gnats) Date: Wed, 11 Apr 2007 09:10:06 GMT Message-Id: <200704110910.l3B9A6EA044361@freefall.freebsd.org> To: perl@FreeBSD.org From: robin@miriup.de Cc: Subject: Re: ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: robin@miriup.de List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 11 Apr 2007 09:10:06 -0000 The following reply was made to PR ports/94668; it has been noted by GNATS. From: robin@miriup.de To: "Edwin Groothuis" 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 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