From owner-freebsd-ports-bugs@FreeBSD.ORG Sun Mar 19 01:50:44 2006 Return-Path: X-Original-To: freebsd-ports-bugs@hub.freebsd.org Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id E4EBD16A423 for ; Sun, 19 Mar 2006 01:50:43 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 20E9443D49 for ; Sun, 19 Mar 2006 01:50:20 +0000 (GMT) (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 k2J1oDLM033946 for ; Sun, 19 Mar 2006 01:50:13 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id k2J1oDWD033945; Sun, 19 Mar 2006 01:50:13 GMT (envelope-from gnats) Resent-Date: Sun, 19 Mar 2006 01:50:13 GMT Resent-Message-Id: <200603190150.k2J1oDWD033945@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, Edwin Groothuis Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4FDAD16A400 for ; Sun, 19 Mar 2006 01:44:05 +0000 (UTC) (envelope-from edwin@mavetju.org) Received: from mail2out.barnet.com.au (mail2out.barnet.com.au [202.83.176.14]) by mx1.FreeBSD.org (Postfix) with ESMTP id C7E2443D45 for ; Sun, 19 Mar 2006 01:44:04 +0000 (GMT) (envelope-from edwin@mavetju.org) Received: by mail2out.barnet.com.au (Postfix, from userid 27) id 4F75A7073C7; Sun, 19 Mar 2006 12:44:02 +1100 (EST) Received: from mail2-auth.barnet.com.au (mail2.barnet.com.au [202.83.176.13]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "*.barnet.com.au", Issuer "BarNet Root Certificate Authority" (verified OK)) by mail2.barnet.com.au (Postfix) with ESMTP id 12C0E7073BC for ; Sun, 19 Mar 2006 12:44:02 +1100 (EST) Received: from k7.mavetju (edwin-3.int.barnet.com.au [10.10.12.2]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mail2-auth.barnet.com.au (Postfix) with ESMTP id 891577073B8 for ; Sun, 19 Mar 2006 12:44:01 +1100 (EST) Received: by k7.mavetju (Postfix, from userid 1001) id 8833B265; Sun, 19 Mar 2006 12:44:00 +1100 (EST) Message-Id: <20060319014400.8833B265@k7.mavetju> Date: Sun, 19 Mar 2006 12:44:00 +1100 (EST) From: Edwin Groothuis To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: Subject: ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Edwin Groothuis List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 19 Mar 2006 01:50:44 -0000 >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 root@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::db prepare failed: unsupported file format(1) at dbdimp.c line 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: