Date: Sun, 19 Mar 2006 12:44:00 +1100 (EST) From: Edwin Groothuis <edwin@mavetju.org> To: FreeBSD-gnats-submit@FreeBSD.org Subject: ports/94668: databases/p5-DBD-SQLite doesn't like new SQLite databases Message-ID: <20060319014400.8833B265@k7.mavetju> Resent-Message-ID: <200603190150.k2J1oDWD033945@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060319014400.8833B265>